Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Product Accessibility
• Related Documents
• Conventions
• Third-Party License Information

1 SQL Developer Concepts and Usage

• 1.1 Installing and Getting Started with SQL Developer
• 1.2 SQL Developer User Interface
  • 1.2.1 Menus for SQL Developer
  • 1.2.2 Restoring the Original "Look and Feel"
• 1.3 Database Objects
  • 1.3.1 Applications (Application Express 3.0.1 and Later)
  • 1.3.2 Cache Groups (Oracle TimesTen In-Memory Database)
  • 1.3.3 Chains
  • 1.3.4 Credentials
  • 1.3.5 Database Destinations
  • 1.3.6 Database Links (Public and Private)
  • 1.3.7 Directories
  • 1.3.8 Editions
  • 1.3.9 Functions
  • 1.3.10 Indexes
  • 1.3.11 Java Sources
  • 1.3.12 Jobs
  • 1.3.13 Job Classes
  • 1.3.14 Materialized Views
  • 1.3.15 Materialized View Logs
  • 1.3.16 Packages
  • 1.3.17 Procedures
  • 1.3.18 Programs
  • 1.3.19 Queues
  • 1.3.20 Queue Tables
  • 1.3.21 Recycle Bin
  • 1.3.22 Replication Schemes (Oracle TimesTen In-Memory Database)
  • 1.3.23 Schedules
  • 1.3.24 Sequences
  • 1.3.25 Synonyms (Public and Private)
  • 1.3.26 Tables
    • 1.3.26.1 Flashback Table Support
  • 1.3.27 Triggers
  • 1.3.28 Types
  • 1.3.29 Users (Other Users)
  • 1.3.30 Views
  • 1.3.31 XML DB Repository
  • 1.3.32 XML Schemas
  • 1.3.33 Captured and Converted Database Objects (for Migration)
• 1.4 Database Connections
  • 1.4.1 Using Folders to Group Connections
  • 1.4.2 Sharing of Connections
  • 1.4.3 Advanced Security for JDBC Connection to the Database
  • 1.4.4 Connections with Operating System (OS) Authentication
  • 1.4.5 Connections with Proxy Authentication
• 1.5 Entering and Modifying Data
• 1.6 Running and Debugging Functions and Procedures
  • 1.6.1 Using Bookmarks When Editing Functions and Procedures
  • 1.6.2 Remote Debugging
  • 1.6.3 Displaying SQL Trace (.trc) Files
  • 1.6.4 Using the PL/SQL Hierarchical Profiler
  • 1.6.5 Setting Expression Watches
• 1.7 Using the SQL Worksheet
  • 1.7.1 SQL*Plus Statements Supported and Not Supported in SQL Worksheet
  • 1.7.2 Script Runner
  • 1.7.3 Execution Plan
  • 1.7.4 Autotrace Pane
  • 1.7.5 DBMS Output Pane
  • 1.7.6 OWA Output Pane
  • 1.7.7 SQL History
  • 1.7.8 Query Builder
  • 1.7.9 Command-Line Interface for SQL Formatting
  • 1.7.10 Gauges: In the SQL Worksheet and User-Defined Reports
• 1.8 Using Snippets to Insert Code Fragments
  • 1.8.1 User-Defined Snippets
• 1.9 Finding Database Objects
• 1.10 Using Versioning
  • 1.10.1 About Subversion and SQL Developer
  • 1.10.2 About CVS and SQL Developer
    • 1.10.2.1 Pending Changes (CVS)
• 1.11 Using DBA Features in SQL Developer
  • 1.11.1 Database Configuration
  • 1.11.2 Resource Manager
  • 1.11.3 Security
  • 1.11.4 Storage
• 1.12 Scheduling Jobs Using SQL Developer
  • 1.12.1 Schedule Design Editor
• 1.13 Spatial Support in SQL Developer
  • 1.13.1 Context Menu Operations on Spatial Data and Metadata
  • 1.13.2 Map Visualization of Spatial Data
    • 1.13.2.1 Visualizing Geometries by Creating and Executing a Query
    • 1.13.2.2 Visualizing Geometries from the Table Data Grid
• 1.14 SQL Developer Reports
  • 1.14.1 About Your Database reports
  • 1.14.2 All Objects reports
  • 1.14.3 Application Express reports
  • 1.14.4 ASH and AWR reports
  • 1.14.5 Charts reports
  • 1.14.6 Database Administration reports
  • 1.14.7 Data Dictionary reports
  • 1.14.8 Jobs reports
  • 1.14.9 PL/SQL reports
  • 1.14.10 Security reports
  • 1.14.11 Streams reports
  • 1.14.12 Table reports
  • 1.14.13 XML reports
  • 1.14.14 Data Modeler reports
  • 1.14.15 User Defined reports
    • 1.14.15.1 User-Defined Report Example: Chart
    • 1.14.15.2 User-Defined Report Example: Dynamic HTML
• 1.15 SQL Developer Preferences
  • 1.15.1 Environment
  • 1.15.2 Code Editor
  • 1.15.3 Compare and Merge
  • 1.15.4 Database
  • 1.15.5 Debugger
  • 1.15.6 Extensions
  • 1.15.7 External Editor
  • 1.15.8 File Types
  • 1.15.9 Global Ignore List
  • 1.15.10 Migration
  • 1.15.11 Mouseover Popups
  • 1.15.12 Shortcut Keys (Accelerator Keys)
  • 1.15.13 Tasks
  • 1.15.14 Unit Test Parameters
  • 1.15.15 Versioning
  • 1.15.16 Web Browser and Proxy
  • 1.15.17 XML Schemas
• 1.16 Location of User-Related Information
• 1.17 Data Modeler in SQL Developer
• 1.18 Oracle TimesTen In-Memory Database Support
• 1.19 Using the Help
• 1.20 Tip of the Day
  • 1.20.1 SQL History Shortcuts
  • 1.20.2 Unshared Worksheets
  • 1.20.3 SQL Worksheet Bookmarks
  • 1.20.4 Oracle Data Miner
  • 1.20.5 Formatted Display of SQL Trace (.trc) Files
  • 1.20.6 Folders for Organizing Connections
  • 1.20.7 Third-Party Databases and SQL Developer
  • 1.20.8 Debugger Ports and Firewalls
  • 1.20.9 Viewing Multiple Tables
  • 1.20.10 Customizing SQL Developer Appearance
  • 1.20.11 Maximizing Tab Panes
  • 1.20.12 Default Path for Running Scripts
  • 1.20.13 Shutting Down and Restarting the Database
  • 1.20.14 Feature Requests
  • 1.20.15 Discussion Forum
  • 1.20.16 Help Text Font Size
  • 1.20.17 Procedure and Function Signatures
  • 1.20.18 Type-Ahead in Navigators
  • 1.20.19 Extended Paste
  • 1.20.20 Closing Tabbed Windows Using the Mouse Wheel
  • 1.20.21 Go to Last Edit Location
  • 1.20.22 Closing Tabbed Windows Using the Context Menu
  • 1.20.23 List of All Open Windows
  • 1.20.24 Go to Subprogram Implementation from Package Window
  • 1.20.25 Select Multiple Table or Column Names in Completion Insight
  • 1.20.26 Startup Time and Automatic Check for Updates
• 1.21 For More Information

2 Migrating Third-Party Databases

• 2.1 Migration: Basic Options and Steps
  • 2.1.1 Migrating Using the Migration Wizard
  • 2.1.2 Copying Selected Tables to Oracle
• 2.2 Migration: Background Information and Guidelines
  • 2.2.1 Overview of Migration
    • 2.2.1.1 How Migration Works
    • 2.2.1.2 Migration Implemented as SQL Developer Extensions
  • 2.2.2 Preparing a Migration Plan
    • 2.2.2.1 Task 1: Determining the Requirements of the Migration Project
    • 2.2.2.2 Task 2: Estimating Workload
    • 2.2.2.3 Task 3: Analyzing Operational Requirements
    • 2.2.2.4 Task 4: Analyzing the Application
    • 2.2.2.5 Task 5: Planning the Migration Project
  • 2.2.3 Before You Start Migrating: General Information
    • 2.2.3.1 Creating a Database User for the Migration Repository
    • 2.2.3.2 Requirements for Creating the Destination Oracle Objects
  • 2.2.4 Before You Start Migrating: Source-Specific Information
    • 2.2.4.1 Before Migrating From IBM DB2
    • 2.2.4.2 Before Migrating From Microsoft SQL Server or Sybase Adaptive Server
    • 2.2.4.3 Before Migrating From Microsoft Access
    • 2.2.4.4 Before Migrating From MySQL
    • 2.2.4.5 Before Migrating From Teradata
  • 2.2.5 Capturing the Source Database
    • 2.2.5.1 Offline Capture
  • 2.2.6 Creating and Customizing the Converted Model
    • 2.2.6.1 Correcting Errors in the Converted Model
  • 2.2.7 Generating the DDL for the Oracle Schema Objects
  • 2.2.8 Migrating the Data
    • 2.2.8.1 Transferring the Data Offline
  • 2.2.9 Making Queries Case Insensitive
  • 2.2.10 Testing the Oracle Database
    • 2.2.10.1 Testing Methodology
    • 2.2.10.2 Testing the Oracle Database
  • 2.2.11 Deploying the Oracle Database
    • 2.2.11.1 Choosing a Rollout Strategy
    • 2.2.11.2 Deploying the Destination Database
• 2.3 SQL Developer User Interface for Migration
  • 2.3.1 Migration Submenu
  • 2.3.2 Other Menus: Migration Items
  • 2.3.3 Migration Preferences
  • 2.3.4 Migration Log Panes
  • 2.3.5 Using the Translation Scratch Editor
• 2.4 Command-Line Interface for Migration

3 Unit Testing with SQL Developer

• 3.1 Overview of Unit Testing
• 3.2 SQL Developer User Interface for Unit Testing
  • 3.2.1 Unit Test Submenu
  • 3.2.2 Other Menus: Unit Test Items
  • 3.2.3 Unit Test Preferences
• 3.3 Unit Test Repository
  • 3.3.1 Managing Repository Users and Administrators
• 3.4 Editing and Running a Unit Test
• 3.5 Using a Dynamic Value Query to Create a Unit Test
• 3.6 Using Lookups to Simplify Unit Test Creation
  • 3.6.1 Providing Values for Input Fields
  • 3.6.2 Automatically Creating Implementations
• 3.7 Using Variable Substitution in Validation Actions
• 3.8 Unit Test Library
• 3.9 Unit Test Reports
• 3.10 Exporting and Importing Unit Test Objects
• 3.11 Command-Line Interface for Unit Testing
• 3.12 Example of Unit Testing (Tutorial)
  • 3.12.1 Create the EMPLOYEES Table
  • 3.12.2 Create the AWARD_BONUS Procedure
  • 3.12.3 Create the Unit Testing Repository
  • 3.12.4 Create a Unit Test
  • 3.12.5 Run the Unit Test
  • 3.12.6 Create and Run an Exception Unit Test
  • 3.12.7 Create a Unit Test Suite
  • 3.12.8 Run the Unit Test Suite

4 Tutorial: Creating Objects for a Small Database

• 4.1 Create a Table (BOOKS)
• 4.2 Create a Table (PATRONS)
• 4.3 Create a Table (TRANSACTIONS)
• 4.4 Create a Sequence
• 4.5 Insert Data into the Tables
• 4.6 Create a View
• 4.7 Create a PL/SQL Procedure
• 4.8 Debug a PL/SQL Procedure
• 4.9 Use the SQL Worksheet for Queries
• 4.10 Script for Creating and Using the Library Tutorial Objects

5 SQL Developer Dialog Boxes and Wizards

• 5.1 Add Extension
• 5.2 Add Schema Error
• 5.3 Analyze Database Migration
• 5.4 Application Migration
• 5.5 Change Type
• 5.6 Check for Updates
• 5.7 Check Out from CVS
• 5.8 Choose Directory
• 5.9 Component Palette
• 5.10 Component Palette: Configure Component Palette
• 5.11 Component Palette: Create Palette Page
• 5.12 Component Palette: New/Edit Code Snippet
• 5.13 Component Palette: New Section / Rename Section
• 5.14 Confirm Drop Application
• 5.15 Confirm Running SQL
• 5.16 Connection Has Uncommitted Changes
• 5.17 Create New Object
• 5.18 Create/Edit Credential
• 5.19 Create/Edit CVS Connection
• 5.20 Create/Edit/Select Database Connection
• 5.21 Rename Model (Migration)
• 5.22 Delete Confirmation (Migration)
• 5.23 Rename Database Item (Migration)
• 5.24 Select Connection
• 5.25 Connection Information
• 5.26 No Connection Found
• 5.27 Connection Rename Error
• 5.28 New Folder (Connections)
• 5.29 Continue After Pause
• 5.30 Select Library
• 5.31 Create Library
• 5.32 Data Import Wizard (Load Data)
• 5.33 Export/Import Connection Descriptors
• 5.34 Create/Edit Database Link
• 5.35 Create/Edit Index
• 5.36 Create Filter
• 5.37 Create/Edit Job Class
• 5.38 Create/Edit Materialized View Log
• 5.39 Create PL/SQL Package
• 5.40 Create PL/SQL Subprogram (Function or Procedure)
• 5.41 Create Program
• 5.42 Create/Edit Role
• 5.43 Create/Edit Sequence
• 5.44 Create SQL File
• 5.45 Create/Edit Synonym
• 5.46 Create Table (quick creation)
• 5.47 Create/Edit Table (with advanced options)
• 5.48 Storage Options
• 5.49 Create/Edit Tablespace
• 5.50 Create Trigger
• 5.51 Create Type (User-Defined)
• 5.52 Create/Edit User
• 5.53 Create/Edit User Defined Report
• 5.54 Create/Edit User Defined Report Folder
• 5.55 Create/Edit View
• 5.56 Create XML Schema
• 5.57 Color Palette and Custom Colors
• 5.58 Configure Extension
• 5.59 Configure File Type Associations
• 5.60 Copy Columns
• 5.61 Custom Filters
• 5.62 Database Copy (Schema Objects)
• 5.63 Database Schema Differences
• 5.64 DDL Panel for Creating or Editing an Object
• 5.65 Debugger - Attach to JPDA
• 5.66 Deploy or Import Application
• 5.67 Describe Object Window
• 5.68 Edit/View Value (Data or Table Column)
• 5.69 Enter Bind Values
• 5.70 Erase from Disk
• 5.71 Error Writing to Export File
• 5.72 Export Error
• 5.73 Export Data
• 5.74 External Locator Configuration
• 5.75 External Tools
• 5.76 Create/Edit External Tool
• 5.77 Choose Offline Options
• 5.78 Edit Font Location
• 5.79 Edit Header or Footer (PDF Formatting)
• 5.80 Edit Join
• 5.81 Feature Missing
• 5.82 Feature Required
• 5.83 File Processing
• 5.84 Filter
• 5.85 Filter Object Types
• 5.86 Filter Schemas
• 5.87 Filter Error
• 5.88 Find/Highlight
• 5.89 Insert Macro
• 5.90 Externally Modified Files
• 5.91 Find/Replace Text
• 5.92 Find Result
• 5.93 Format Properties
• 5.94 Generate Patch
• 5.95 Go to Bookmark
• 5.96 Go to Line Number
• 5.97 Go to Line Number: Error
• 5.98 History
• 5.99 Import to CVS
• 5.100 Invalid Database Version
• 5.101 Load Keyboard Scheme
• 5.102 Log In to CVS
• 5.103 Maintain Spatial Metadata
• 5.104 Manage Columns
• 5.105 Modify Value
• 5.106 Data Move Details
• 5.107 New Procedure (Refactoring)
• 5.108 No Lock
• 5.109 No Object Found
• 5.110 No Object Selected
• 5.111 Object Preferences
• 5.112 Offline Generation Error - Destination Directory
• 5.113 Open File
• 5.114 Oracle-Only Report
• 5.115 Oracle Proxy Authentication
• 5.116 Paste
• 5.117 Privilege Warning for Migration
• 5.118 Recent Files
• 5.119 Create Repository
• 5.120 Delete or Truncate Repository
• 5.121 Capture Microsoft Access Exporter XML
• 5.122 Rename Local Variable
• 5.123 Rename Tab
• 5.124 Rename Procedure
• 5.125 Select Current Repository
• 5.126 Cannot Capture Table
• 5.127 Report Panel
• 5.128 Reset Expired Password (Enter New Password)
• 5.129 Revision Lister
• 5.130 Run/Debug/Profile PL/SQL
• 5.131 Create/Edit Breakpoint
• 5.132 Save/Save As, or Select File
• 5.133 Save Files
• 5.134 Unable to Save Files
• 5.135 Save Style Settings
• 5.136 Schema Differences Source or Destination Error
• 5.137 Script Execution Failed
• 5.138 Script Generation Complete
• 5.139 Set Data Mapping
• 5.140 Add/Edit Rule
• 5.141 Set Encoding
• 5.142 Set Pause Continue
• 5.143 Sign In (checking for updates)
• 5.144 Single Record View
• 5.145 Save Snippet (User-Defined)
• 5.146 Edit Snippets (User-Defined)
• 5.147 Show SQL
• 5.148 Start Date, End Date, Repeat Interval, Comments (Scheduler)
• 5.149 Subversion: Add Property
• 5.150 Subversion: Add to Source Control
• 5.151 Subversion: Apply Patch
• 5.152 Subversion: Branch/Tag
• 5.153 Subversion: Check Out from Subversion
• 5.154 Subversion: Commit Resources
• 5.155 Subversion: Commit Working Copy
• 5.156 Subversion: Confirm Checkout
• 5.157 Subversion: Create Remote Directory
• 5.158 Subversion: Create Subversion Repository
• 5.159 Subversion: Create/Edit Subversion Connection
• 5.160 Subversion: Delete Resources
• 5.161 Subversion: Edit Configuration File
• 5.162 Subversion: Export Files
• 5.163 Subversion: Export Subversion Connections
• 5.164 Subversion: Ignore
• 5.165 Subversion: Import Subversion Connections
• 5.166 Subversion: Import to Subversion
• 5.167 Subversion: Lock Resources
• 5.168 Subversion: Merge
• 5.169 Subversion: Pending Changes
• 5.170 Subversion: Properties
• 5.171 Subversion: Remove from Subversion
• 5.172 Subversion: Repository Browser
• 5.173 Subversion: Revert Local Changes
• 5.174 Subversion: Switch
• 5.175 Subversion: Unlock Resources
• 5.176 Subversion: Update Resources
• 5.177 Subversion: Update Working Copy
• 5.178 Subversion: Versioning Properties
• 5.179 Third-Party Database Objects
• 5.180 Unable to Connect
• 5.181 Unable to Open File
• 5.182 Unit Testing: Action Required
• 5.183 Unit Testing: Add Category
• 5.184 Unit Testing: Add Data Type
• 5.185 Unit Testing: Add Item to Library
• 5.186 Unit Testing: Add Test Implementation
• 5.187 Unit Testing: Add Test Suite
• 5.188 Unit Testing: Add Tests or Suites to a Suite
• 5.189 Unit Testing: Copy or Rename Unit Test
• 5.190 Unit Testing: Create Unit Test
• 5.191 Unit Testing: Manage Users
• 5.192 Unit Testing: Rename Test Implementation
• 5.193 Unit Testing: Result of Operation
• 5.194 Unit Testing: Synchronize Unit Test
• 5.195 Export Wizard (Unload Database Objects and Data)
• 5.196 Unsupported Database Version
• 5.197 Validate Geometry
• 5.198 Windows
• 5.199 XMLType Column Properties

Index