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 Destination Groups
  • 1.3.8 Directories
  • 1.3.9 Editions
  • 1.3.10 File Watchers
  • 1.3.11 Functions
  • 1.3.12 Indexes
  • 1.3.13 Java Sources
  • 1.3.14 Jobs
  • 1.3.15 Job Classes
  • 1.3.16 Materialized Views
  • 1.3.17 Materialized View Logs
  • 1.3.18 Multitenant Container Database (CDB)
  • 1.3.19 Packages
  • 1.3.20 Procedures
  • 1.3.21 Programs
  • 1.3.22 Queues
  • 1.3.23 Queue Tables
  • 1.3.24 Recycle Bin
  • 1.3.25 Replication Schemes (Oracle TimesTen In-Memory Database)
  • 1.3.26 Schedules
  • 1.3.27 Sequences
  • 1.3.28 Synonyms (Public and Private)
  • 1.3.29 Tables
    • 1.3.29.1 Flashback Table Support
  • 1.3.30 Triggers
  • 1.3.31 Types
  • 1.3.32 Users (Other Users)
  • 1.3.33 Views
  • 1.3.34 XML DB Repository
  • 1.3.35 XML Schemas
  • 1.3.36 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 Multitenant Container Database (CDB)
  • 1.11.2 Database Configuration
  • 1.11.3 Database Status
  • 1.11.4 Data Pump
  • 1.11.5 RMAN Backup/Recovery
    • 1.11.5.1 Using Action Jobs
  • 1.11.6 Resource Manager
  • 1.11.7 SQL Translator FrameWork
  • 1.11.8 Scheduler
  • 1.11.9 Security
  • 1.11.10 Storage
• 1.12 Scheduling Jobs Using SQL Developer
  • 1.12.1 Scheduler Design Editor
• 1.13 Deploying Objects Using the Cart
  • 1.13.1 Cart Versus Database Export Wizard
• 1.14 Spatial Support in SQL Developer
  • 1.14.1 Context Menu Operations on Spatial Data and Metadata
  • 1.14.2 Map Visualization of Spatial Data
    • 1.14.2.1 Visualizing Geometries by Creating and Executing a Query
    • 1.14.2.2 Visualizing Geometries from the Table Data Grid
• 1.15 Change Manager Support in SQL Developer
  • 1.15.1 Change Plan Administrators and Developers
  • 1.15.2 Developing Change Plans with SQL Developer
    • 1.15.2.1 Creating a Repository Connection
    • 1.15.2.2 Creating and Deleting Change Plans
    • 1.15.2.3 Adding and Updating Change Items
    • 1.15.2.4 Using Change Plans to Capture Change in SQL Developer
  • 1.15.3 Change Manager Actions to Perform with Enterprise Manager
    • 1.15.3.1 Creating Change Plans from Change Manager Schema Comparisons
    • 1.15.3.2 Deploying Change Plans
• 1.16 Application Express Listener Administration
  • 1.16.1 About Oracle Application Express Listener
  • 1.16.2 Application Express Listener Administration Toolbar and Context Menu
  • 1.16.3 Connecting to Application Express Listener Server
  • 1.16.4 Listener Navigator: Global and Database Settings
    • 1.16.4.1 Connections
    • 1.16.4.2 RESTful Connections
    • 1.16.4.3 Security
    • 1.16.4.4 Cache Files
    • 1.16.4.5 Environment
    • 1.16.4.6 Excel
• 1.17 SQL Developer Reports
  • 1.17.1 About Your Database reports
  • 1.17.2 All Objects reports
  • 1.17.3 Application Express reports
  • 1.17.4 ASH and AWR reports
  • 1.17.5 Charts reports
  • 1.17.6 Database Administration reports
  • 1.17.7 Data Dictionary reports
  • 1.17.8 Scheduler reports
  • 1.17.9 PL/SQL reports
  • 1.17.10 Security reports
  • 1.17.11 Streams reports
  • 1.17.12 Table reports
  • 1.17.13 XML reports
  • 1.17.14 Data Modeler reports
  • 1.17.15 User Defined reports
    • 1.17.15.1 User-Defined Report Example: Chart
    • 1.17.15.2 User-Defined Report Example: Dynamic HTML
• 1.18 SQL Developer Preferences
  • 1.18.1 Environment
  • 1.18.2 Change Management Parameters
  • 1.18.3 Code Editor
  • 1.18.4 Compare and Merge
  • 1.18.5 Database
  • 1.18.6 Debugger
  • 1.18.7 Extensions
  • 1.18.8 External Editor
  • 1.18.9 File Types
  • 1.18.10 Global Ignore List
  • 1.18.11 Migration
  • 1.18.12 Mouseover Popups
  • 1.18.13 Shortcut Keys (Accelerator Keys)
  • 1.18.14 Unit Test Parameters
  • 1.18.15 Versioning
  • 1.18.16 Web Browser and Proxy
  • 1.18.17 XML Schemas
• 1.19 Location of User-Related Information
• 1.20 Data Modeler in SQL Developer
• 1.21 Oracle TimesTen In-Memory Database Support
• 1.22 Using the Help
• 1.23 Tip of the Day
  • 1.23.1 SQL History Shortcuts
  • 1.23.2 Unshared Worksheets
  • 1.23.3 SQL Worksheet Bookmarks
  • 1.23.4 Oracle Data Miner
  • 1.23.5 Formatted Display of SQL Trace (.trc) Files
  • 1.23.6 Keyboard Navigation: Alt + Page Down/Up to Move Among Tabs
  • 1.23.7 Folders for Organizing Connections
  • 1.23.8 Third-Party Databases and SQL Developer
  • 1.23.9 Debugger Ports and Firewalls
  • 1.23.10 Viewing Multiple Tables
  • 1.23.11 Customizing SQL Developer Appearance
  • 1.23.12 Maximizing Tab Panes
  • 1.23.13 Default Path for Running Scripts
  • 1.23.14 Shutting Down and Restarting the Database
  • 1.23.15 Feature Requests
  • 1.23.16 Discussion Forums
  • 1.23.17 Help Text Font Size
  • 1.23.18 Procedure and Function Signatures
  • 1.23.19 Type-Ahead in Navigators
  • 1.23.20 Extended Paste
  • 1.23.21 Closing Tabbed Windows Using the Mouse Wheel
  • 1.23.22 Go to Last Edit Location
  • 1.23.23 Closing Tabbed Windows Using the Context Menu
  • 1.23.24 List of All Open Windows
  • 1.23.25 Go to Subprogram Implementation from Package Window
  • 1.23.26 Select Multiple Table or Column Names in Completion Insight
  • 1.23.27 Startup Time and Automatic Check for Updates
• 1.24 For More Information

2 SQL Developer: 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 SQL Developer: Unit Testing

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

6 SQL Developer Accessibility Information

• 6.1 About Oracle SQL Developer Accessibility
• 6.2 Using a Screen Reader and Java Access Bridge with Oracle SQL Developer
• 6.3 Oracle SQL Developer Features that Support Accessibility
  • 6.3.1 Keyboard Access
  • 6.3.2 Screen Reader Readability
  • 6.3.3 Flexibility in Font and Color Choices
  • 6.3.4 No Audio-only Feedback
  • 6.3.5 No Dependency on Blinking Cursor and Animation
  • 6.3.6 Screen Magnifier Usability
  • 6.3.7 How to Change the Editor or Tabbed View of a File
  • 6.3.8 How to Read Text in a Multiline Edit Field
  • 6.3.9 How to Read the Line Number in the Source Editor
  • 6.3.10 How to Access Exception Stack HTML Links and Generated Javadoc Links in the Log Window
• 6.4 Recommendations for Customizing Oracle SQL Developer
  • 6.4.1 How to Customize the Accelerators Keys
  • 6.4.2 How to Pass a Conflicting Accelerator Key to Oracle SQL Developer
  • 6.4.3 How to Change the Look and Feel of SQL Developer
  • 6.4.4 How to Customize the Fonts in Code Editors
  • 6.4.5 How to Customize Syntax Highlighting
  • 6.4.6 How to Display Line Numbers in Code Editors
  • 6.4.7 How to Change the Timing for Completion Insight
  • 6.4.8 How to Specify the Columns in the Debugger
• 6.5 Highly Visual Features of Oracle SQL Developer

Index