1/12
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
About SQL Developer
1.2
Installing and Getting Started with SQL Developer
1.3
SQL Developer User Interface
1.3.1
Menus for SQL Developer
1.3.2
Restoring the Original "Look and Feel"
1.4
Database Objects
1.4.1
Applications (Application Express 3.0.1 and Later)
1.4.2
Cache Groups (Oracle TimesTen In-Memory Database)
1.4.3
Chains
1.4.4
Credentials
1.4.5
Database Destinations
1.4.6
Database Links (Public and Private)
1.4.7
Destination Groups
1.4.8
Directories
1.4.9
Editions
1.4.10
File Watchers
1.4.11
Functions
1.4.12
Indexes
1.4.13
Java Sources
1.4.14
Jobs
1.4.15
Job Classes
1.4.16
Materialized Views
1.4.17
Materialized View Logs
1.4.18
Multitenant Container Database (CDB)
1.4.19
Packages
1.4.20
Procedures
1.4.21
Programs
1.4.22
Queues
1.4.23
Queue Tables
1.4.24
Recycle Bin
1.4.25
Replication Schemes (Oracle TimesTen In-Memory Database)
1.4.26
Schedules
1.4.27
Sequences
1.4.28
Synonyms (Public and Private)
1.4.29
Tables
1.4.29.1
Flashback Table Support
1.4.30
Triggers
1.4.31
Types
1.4.32
Users (Other Users)
1.4.33
Views
1.4.34
Window Groups
1.4.35
Windows
1.4.36
XML DB Repository
1.4.37
XML Schemas
1.4.38
Captured and Converted Database Objects (for Migration)
1.5
Database Connections
1.5.1
Using Folders to Group Connections
1.5.2
Sharing of Connections
1.5.3
Advanced Security for JDBC Connection to the Database
1.5.4
Connections with Operating System (OS) Authentication
1.5.5
Connections with Proxy Authentication
1.5.6
Connections with SSH Authentication
1.6
Entering and Modifying Data
1.7
Running and Debugging Functions and Procedures
1.7.1
Using Bookmarks When Editing Functions and Procedures
1.7.2
Remote Debugging
1.7.3
Displaying SQL Trace (.trc) Files
1.7.4
Using the PL/SQL Hierarchical Profiler
1.7.5
Setting Expression Watches
1.8
Using the SQL Worksheet
1.8.1
SQL*Plus Statements Supported and Not Supported in SQL Worksheet
1.8.2
Script Runner
1.8.3
Execution Plan
1.8.4
Autotrace Pane
1.8.5
DBMS Output Pane
1.8.6
OWA Output Pane
1.8.7
SQL History
1.8.8
Query Builder
1.8.9
Command-Line Interface for SQL Formatting
1.8.10
SQL Worksheet "Hints" for Formatting Output
1.8.11
Gauges: In the SQL Worksheet and User-Defined Reports
1.8.12
Entering OLAP DML Statements in the SQL Worksheet
1.9
Using Snippets to Insert Code Fragments
1.9.1
User-Defined Snippets
1.10
Finding Database Objects
1.11
Using Recent Objects
1.12
Using Versioning
1.12.1
About Subversion and SQL Developer
1.12.2
About Perforce and SQL Developer
1.12.3
About CVS and SQL Developer
1.12.4
Pending Changes
1.13
Using DBA Features in SQL Developer
1.13.1
Container Database (CDB)
1.13.2
Database Configuration
1.13.3
Database Status
1.13.4
Data Pump
1.13.5
Performance
1.13.6
RMAN Backup/Recovery
1.13.6.1
Using Action Jobs
1.13.7
Resource Manager
1.13.8
SQL Translator FrameWork
1.13.9
Scheduler
1.13.10
Security
1.13.11
Storage
1.14
Scheduling Jobs Using SQL Developer
1.14.1
Scheduler Design Editor
1.15
Using the Cart
1.15.1
Cart Versus Database Export Wizard
1.16
Spatial Support in SQL Developer
1.16.1
Context Menu Operations on Spatial Data and Metadata
1.16.2
Map Visualization of Spatial Data
1.16.2.1
Visualizing Geometries by Creating and Executing a Query
1.16.2.2
Visualizing Geometries from the Table Data Grid
1.17
Change Manager Support in SQL Developer
1.17.1
Change Plan Administrators and Developers
1.17.2
Developing Change Plans with SQL Developer
1.17.2.1
Creating a Repository Connection
1.17.2.2
Creating and Deleting Change Plans
1.17.2.3
Adding and Updating Change Items
1.17.2.4
Using Change Plans to Capture Change in SQL Developer
1.17.3
Change Manager Actions to Perform with Enterprise Manager
1.17.3.1
Creating Change Plans from Change Manager Schema Comparisons
1.17.3.2
Deploying Change Plans
1.18
Oracle REST Data Services Administration
1.18.1
About Oracle REST Data Services
1.18.2
Oracle REST Data Services Administration Toolbar and Context Menu
1.18.3
Connecting to Oracle REST Data Services
1.18.4
REST Data Services Navigator: Global and Database Settings
1.18.4.1
Connections
1.18.4.2
RESTful Connections (Database Settings only)
1.18.4.3
Security
1.18.4.4
Cache Files
1.18.4.5
Environment
1.18.4.6
Excel
1.19
RESTful Services Administration
1.19.1
About RESTful Services
1.19.2
RESTful Services Terminology
1.19.3
RESTful Services Requirements and Setup
1.19.4
RESTful Services Administration Pane
1.20
SQL Developer Reports
1.20.1
About Your Database reports
1.20.2
All Objects reports
1.20.3
Application Express reports
1.20.4
ASH and AWR reports
1.20.5
Charts reports
1.20.6
Database Administration reports
1.20.7
Data Dictionary reports
1.20.8
Scheduler reports
1.20.9
PL/SQL reports
1.20.10
Security reports
1.20.11
Streams reports
1.20.12
Table reports
1.20.13
XML reports
1.20.14
Data Modeler reports
1.20.15
User Defined reports
1.20.15.1
User-Defined Report Example: Chart
1.20.15.2
User-Defined Report Example: Dynamic HTML
1.21
SQL Developer Preferences
1.21.1
Environment
1.21.2
Change Management Parameters
1.21.3
Code Editor
1.21.4
Compare and Merge
1.21.5
Database
1.21.6
Debugger
1.21.7
Extensions
1.21.8
External Editor
1.21.9
File Types
1.21.10
Global Ignore List
1.21.11
Migration
1.21.12
Mouseover Popups
1.21.13
Shortcut Keys (Accelerator Keys)
1.21.14
Unit Test Parameters
1.21.15
Usage Reporting
1.21.16
Versioning
1.21.17
Web Browser and Proxy
1.21.18
XML Schemas
1.22
Location of User-Related Information
1.23
Java Development Kit (JDK) Location
1.24
Command-Line Interface for SQL Developer
1.25
Data Modeler in SQL Developer
1.26
Oracle TimesTen In-Memory Database Support
1.27
Using the Help
1.28
SQL Developer Usage Suggestions
1.28.1
SQL History Shortcuts
1.28.2
Unshared Worksheets
1.28.3
SQL Worksheet Bookmarks
1.28.4
Oracle Data Miner
1.28.5
Formatted Display of SQL Trace (.trc) Files
1.28.6
Keyboard Navigation: Alt + Page Down/Up to Move Among Tabs
1.28.7
Folders for Organizing Connections
1.28.8
Third-Party Databases and SQL Developer
1.28.9
Debugger Ports and Firewalls
1.28.10
Viewing Multiple Tables
1.28.11
Customizing SQL Developer Appearance
1.28.12
Maximizing Tab Panes
1.28.13
Default Path for Running Scripts
1.28.14
Shutting Down and Restarting the Database
1.28.15
Feature Requests
1.28.16
Discussion Forums
1.28.17
Help Text Font Size
1.28.18
Procedure and Function Signatures
1.28.19
Type-Ahead in Navigators
1.28.20
Extended Paste
1.28.21
Closing Tabbed Windows Using the Mouse Wheel
1.28.22
Go to Last Edit Location
1.28.23
Closing Tabbed Windows Using the Context Menu
1.28.24
List of All Open Windows
1.28.25
Go to Subprogram Implementation from Package Window
1.28.26
Select Multiple Table or Column Names in Completion Insight
1.28.27
Startup Time and Automatic Check for Updates
1.29
For More Information About SQL Developer
1.30
Oracle Legal Notices
1.30.1
Copyright Notice
1.30.2
Trademark Notice
1.30.3
License Restrictions Warranty/Consequential Damages Disclaimer
1.30.4
Warranty Disclaimer
1.30.5
Restricted Rights Notice
1.30.6
Hazardous Applications Notice
1.30.7
Third-Party Content, Products, and Services Disclaimer
1.30.8
Alpha and Beta Draft Documentation Notice
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
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
Unit Testing Best Practices
3.12.1
Strategy
3.12.2
Test Suites
3.12.3
Test Naming
3.12.4
Avoiding Test Naming Clashes
3.12.5
Test Implementations
3.12.6
Library
3.12.7
Lookups
3.12.8
Test and Suite Execution
3.12.9
Reports
3.13
Example of Unit Testing (Tutorial)
3.13.1
Create the EMPLOYEES Table
3.13.2
Create the AWARD_BONUS Procedure
3.13.3
Create the Unit Testing Repository
3.13.4
Create a Unit Test
3.13.5
Run the Unit Test
3.13.6
Create and Run an Exception Unit Test
3.13.7
Create a Unit Test Suite
3.13.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
Advanced Properties (Connections)
5.4
Application Migration
5.5
Associate Repository
5.6
Cart Error (Objects Not Available)
5.7
Change Type
5.8
Check for Updates
5.9
Check Out from CVS
5.10
Choose Directory
5.11
Clone Pluggable Database
5.12
Color Palette and Custom Colors
5.13
Configure Extension
5.14
Configure File Type Associations
5.15
Copy Columns
5.16
Copy Objects
5.17
Component Palette
5.18
Component Palette: Configure Component Palette
5.19
Component Palette: Create Palette Page
5.20
Component Palette: New/Edit Code Snippet
5.21
Component Palette: New Section / Rename Section
5.22
Confirm Drop Application
5.23
Confirm Running SQL
5.24
Connection Has Uncommitted Changes
5.25
Create New Object
5.26
Create/Edit Chain
5.27
Create/Edit Credential
5.28
Create/Edit CVS Connection
5.29
Create/Edit/Select Database Connection
5.30
New/Edit Cloud Connection
5.30.1
Advanced Connection Information
5.31
Rename Model (Migration)
5.32
Delete Confirmation
5.33
Delete Confirmation (Migration)
5.34
Rename Database Item (Migration)
5.35
Select Connection
5.36
Connection Information
5.37
No Connection Found
5.38
Connection Rename Error
5.39
New Folder (Connections)
5.40
Continue After Pause
5.41
Select Library
5.42
Create Library
5.43
Data Import Wizard (Load Data)
5.44
Export/Import Connections
5.44.1
Export Connections
5.44.2
Import Connections
5.45
Create/Edit Database Destination
5.46
Create/Edit Destination Group (Database or External)
5.47
Create/Edit Database Link
5.48
Create/Edit Index
5.49
Create File Watcher
5.50
Create Filter
5.51
Create Function or Procedure
5.52
Create/Edit Job
5.53
Create/Edit Job Class
5.54
Create/Edit Materialized View Log
5.55
Create PL/SQL Package
5.56
Create Pluggable Database
5.57
Create/Edit Program
5.58
Create/Edit Role
5.59
Create/Edit Schedule
5.60
Create/Edit Sequence
5.61
Create SQL File
5.62
Create/Edit Synonym
5.63
Create Table (quick creation)
5.64
Create/Edit Table (with advanced options)
5.65
Storage Options
5.66
Create/Edit Tablespace
5.67
Create Trigger
5.68
Create Type (User-Defined)
5.69
Create/Edit User
5.70
Create/Edit User Defined Report
5.71
Create/Edit User Defined Report Folder
5.72
Create/Edit View
5.73
Create Window
5.74
Create Window Group
5.75
Create XML Document from XML Schema
5.76
Create XML Schema
5.77
Custom Filters
5.78
Customize Toolbars
5.79
Data Pump Export
5.80
Data Pump Import
5.81
Database Copy
5.82
Database Differences
5.83
Database Export (Unload Database Objects and Data)
5.84
DDL Panel for Creating or Editing an Object
5.85
Debugger - Attach to JPDA
5.86
Deploy or Import Application
5.87
Deploy Objects to Cloud
5.87.1
Unsupported Cart Object for Cloud Deployment
5.87.2
Other Errors (Invalid or Missing Entries)
5.88
Describe Object Window
5.89
Diff Objects
5.90
Drop Pluggable Database
5.91
Edit/View Value (Data or Table Column)
5.92
Enter Bind Values
5.93
Erase from Disk
5.94
Error Writing to Export File
5.95
Export Error
5.96
Export Data
5.97
Export Objects
5.98
Export: Unique Names Warning
5.99
External Locator Configuration
5.100
External Tools
5.101
Create/Edit External Tool
5.102
Choose Offline Options
5.103
Edit Font Location
5.104
Edit Header or Footer (PDF Formatting)
5.105
Edit Join
5.106
Feature Missing
5.107
Feature Required
5.108
File Processing
5.109
Filter
5.110
Filter Object Types
5.111
Filter Schemas
5.112
Filter Error
5.113
Find/Highlight
5.114
Git: Add
5.115
Git: Add All
5.116
Git: Add to .gitignore File
5.117
Git: Checkout Revision
5.118
Git: Clone from Git
5.119
Git: Commit
5.120
Git: Commit All
5.121
Git: Create Branch
5.122
Git: Create Tag
5.123
Git: Export Committed Changes
5.124
Git: Export Uncommitted Changes
5.125
Git: Fetch from Git
5.126
Git: Initialize Repository
5.127
Git: Merge
5.128
Git: Pull from Git
5.129
Git: Push to Git
5.130
Git: Revert
5.131
Insert Macro
5.132
Externally Modified Files
5.133
Find/Replace Text
5.134
Find Result
5.135
Format Properties (Advanced Formatting)
5.136
Generate Patch
5.137
Go to Bookmark
5.138
Go to Line Number
5.139
Go to Line Number: Error
5.140
History
5.141
Import to CVS
5.142
Install SQL Translator
5.142.1
Installing a Translator and Creating a Profile: Usage Notes
5.143
Invalid Database Version
5.144
Load Extension
5.145
Load Keyboard Scheme
5.146
LOB Descriptors
5.147
Log In to CVS
5.148
Maintain Spatial Metadata
5.149
Manage Columns
5.150
Manage Features and Updates
5.151
Map Connection
5.152
Merge Migration Projects
5.153
Modify Pluggable State
5.154
Modify Value
5.155
Data Move Details
5.156
New/Edit Change Set
5.157
New Procedure (Refactoring)
5.158
No Lock
5.159
No Object Found
5.160
No Object Selected
5.161
Object Preferences
5.162
Offline Generation Error - Destination Directory
5.163
Open File
5.164
Oracle-Only Report
5.165
Paste
5.166
Perforce: Add Files to Perforce
5.167
Perforce: Connection
5.168
Perforce: Create Changelist
5.169
Perforce: Delete Files
5.170
Perforce: Login
5.171
Perforce: Open Files for Edit
5.172
Perforce: Revert Files
5.173
Perforce: Sync Files
5.174
Perforce: Submit Changelist
5.175
Plug In Pluggable Database
5.176
Print Preview
5.177
Privilege Warning for Migration
5.178
Recent Files
5.179
Delete or Truncate Repository
5.179.1
Error Truncating Repository
5.180
Capture Microsoft Access Exporter XML
5.181
Rename Local Variable
5.182
Rename Tab
5.183
Rename Procedure
5.184
REST Data Services Connection
5.185
REST Data Services Connection: Remove Connection
5.186
RESTful Services Wizard and Object Dialog Boxes
5.186.1
Resource Module
5.186.2
Resource Template
5.186.3
Resource Handler
5.186.4
RESTful Summary
5.187
RESTful Services Connection
5.188
RESTful Services Privilege
5.189
Select Current Repository
5.190
Cannot Capture Table
5.191
Report Panel
5.192
Reset Expired Password (Enter New Password)
5.193
Revision Lister
5.194
Run/Debug/Profile PL/SQL
5.195
Create/Edit Breakpoint
5.196
Save/Save As, or Select File
5.197
Save or Open Cart Tool Configuration
5.198
Save Files
5.199
Unable to Save Files
5.200
Save Style Settings
5.201
Schema Differences Source or Destination Error
5.202
Script Execution Failed
5.203
Script Generation Complete
5.204
Set Data Mapping
5.205
Add/Edit Rule
5.206
Set Encoding
5.207
Set Pause Continue
5.208
Shared Wizard Pages
5.208.1
Types
5.208.2
Specify Objects
5.208.3
Data
5.208.4
Summary
5.209
Sign In (checking for updates)
5.210
Single Record View
5.211
Save Snippet (User-Defined)
5.212
Edit Snippets (User-Defined)
5.213
Show SQL
5.214
Start Date, End Date, Repeat Interval, Comments (Scheduler)
5.215
Subversion: Add Property
5.216
Subversion: Add to Source Control
5.217
Subversion: Apply Patch
5.218
Subversion: Branch/Tag
5.219
Subversion: Check Out from Subversion
5.220
Subversion: Commit Resources
5.221
Subversion: Commit Working Copy
5.222
Subversion: Confirm Checkout
5.223
Subversion: Create Remote Directory
5.224
Subversion: Create Subversion Repository
5.225
Subversion: Create/Edit Subversion Connection
5.226
Subversion: Delete Resources
5.227
Subversion: Edit Configuration File
5.228
Subversion: Export Files
5.229
Subversion: Export Subversion Connections
5.230
Subversion: Ignore
5.231
Subversion: Import Subversion Connections
5.232
Subversion: Import to Subversion
5.233
Subversion: Lock Resources
5.234
Subversion: Merge
5.235
Subversion: Pending Changes
5.236
Subversion: Properties
5.237
Subversion: Remove from Subversion
5.238
Subversion: Repository Browser
5.239
Subversion: Revert Local Changes
5.240
Subversion: Switch
5.241
Subversion: Unlock Resources
5.242
Subversion: Update Resources
5.243
Subversion: Update Working Copy
5.244
Subversion: Versioning Properties
5.245
Third-Party Database Objects
5.246
Unable to Connect
5.247
Unable to Open File
5.248
Unit Testing: Action Required
5.249
Unit Testing: Add Category
5.250
Unit Testing: Add Data Type
5.251
Unit Testing: Add Item to Library
5.252
Unit Testing: Add Test Implementation
5.253
Unit Testing: Add Test Suite
5.254
Unit Testing: Add Tests or Suites to a Suite
5.255
Unit Testing: Copy or Rename Unit Test
5.256
Unit Testing: Create Unit Test
5.257
Unit Testing: Manage Users
5.258
Unit Testing: Rename Test Implementation
5.259
Unit Testing: Result of Operation
5.260
Unit Testing: Synchronize Unit Test
5.261
Unplug Pluggable Database
5.262
Unsupported Database Version
5.263
Validate Geometry
5.264
View Whole Value
5.265
Windows
5.266
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
Scripting on this page enhances content navigation, but does not change the content in any way.