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
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
Packages
1.3.19
Procedures
1.3.20
Programs
1.3.21
Queues
1.3.22
Queue Tables
1.3.23
Recycle Bin
1.3.24
Replication Schemes (Oracle TimesTen In-Memory Database)
1.3.25
Schedules
1.3.26
Sequences
1.3.27
Synonyms (Public and Private)
1.3.28
Tables
1.3.28.1
Flashback Table Support
1.3.29
Triggers
1.3.30
Types
1.3.31
Users (Other Users)
1.3.32
Views
1.3.33
XML DB Repository
1.3.34
XML Schemas
1.3.35
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
Container Database
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
Scheduler
1.11.8
Security
1.11.9
Storage
1.11.10
SQL Translation Profiles
1.12
Scheduling Jobs Using SQL Developer
1.12.1
Scheduler Design Editor
1.13
Deploying Objects Using the SQL Developer Cart
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
User Interface for Change Manager Support
1.15.3
Developing Change Plans with SQL Developer
1.15.3.1
Creating a Repository Connection
1.15.3.2
Creating and Deleting Change Plans
1.15.3.3
Adding and Updating Change Items
1.15.3.4
Using Change Plans to Capture Change in SQL Developer
1.15.4
Change Manager Actions to Perform with Enterprise Manager
1.15.4.1
Creating Change Plans from Change Manager Schema Comparisons
1.15.4.2
Deploying Change Plans
1.16
SQL Developer Reports
1.16.1
About Your Database reports
1.16.2
All Objects reports
1.16.3
Application Express reports
1.16.4
ASH and AWR reports
1.16.5
Charts reports
1.16.6
Database Administration reports
1.16.7
Data Dictionary reports
1.16.8
Scheduler reports
1.16.9
PL/SQL reports
1.16.10
Security reports
1.16.11
Streams reports
1.16.12
Table reports
1.16.13
XML reports
1.16.14
Data Modeler reports
1.16.15
User Defined reports
1.16.15.1
User-Defined Report Example: Chart
1.16.15.2
User-Defined Report Example: Dynamic HTML
1.17
SQL Developer Preferences
1.17.1
Environment
1.17.2
Change Management Parameters
1.17.3
Code Editor
1.17.4
Compare and Merge
1.17.5
Database
1.17.6
Debugger
1.17.7
Extensions
1.17.8
External Editor
1.17.9
File Types
1.17.10
Global Ignore List
1.17.11
Migration
1.17.12
Mouseover Popups
1.17.13
Shortcut Keys (Accelerator Keys)
1.17.14
Unit Test Parameters
1.17.15
Versioning
1.17.16
Web Browser and Proxy
1.17.17
XML Schemas
1.18
Location of User-Related Information
1.19
Data Modeler in SQL Developer
1.20
Oracle TimesTen In-Memory Database Support
1.21
Using the Help
1.22
Tip of the Day
1.22.1
SQL History Shortcuts
1.22.2
Unshared Worksheets
1.22.3
SQL Worksheet Bookmarks
1.22.4
Oracle Data Miner
1.22.5
Formatted Display of SQL Trace (.trc) Files
1.22.6
Keyboard Navigation: Alt + Page Down/Up to Move Among Tabs
1.22.7
Folders for Organizing Connections
1.22.8
Third-Party Databases and SQL Developer
1.22.9
Debugger Ports and Firewalls
1.22.10
Viewing Multiple Tables
1.22.11
Customizing SQL Developer Appearance
1.22.12
Maximizing Tab Panes
1.22.13
Default Path for Running Scripts
1.22.14
Shutting Down and Restarting the Database
1.22.15
Feature Requests
1.22.16
Discussion Forums
1.22.17
Help Text Font Size
1.22.18
Procedure and Function Signatures
1.22.19
Type-Ahead in Navigators
1.22.20
Extended Paste
1.22.21
Closing Tabbed Windows Using the Mouse Wheel
1.22.22
Go to Last Edit Location
1.22.23
Closing Tabbed Windows Using the Context Menu
1.22.24
List of All Open Windows
1.22.25
Go to Subprogram Implementation from Package Window
1.22.26
Select Multiple Table or Column Names in Completion Insight
1.22.27
Startup Time and Automatic Check for Updates
1.23
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
Rename Model (Migration)
5.23
Delete Confirmation
5.24
Delete Confirmation (Migration)
5.25
Rename Database Item (Migration)
5.26
Select Connection
5.27
Connection Information
5.28
No Connection Found
5.29
Connection Rename Error
5.30
New Folder (Connections)
5.31
Continue After Pause
5.32
Select Library
5.33
Create Library
5.34
Data Import Wizard (Load Data)
5.35
Export/Import Connection Descriptors
5.36
Create Database Destination
5.37
Create Destination Group (Database or External)
5.38
Create/Edit Database Link
5.39
Create/Edit Index
5.40
Create Filter
5.41
Create/Edit Job
5.42
Create/Edit Job Class
5.43
Create/Edit Materialized View Log
5.44
Create PL/SQL Package
5.45
Create PL/SQL Subprogram (Function or Procedure)
5.46
Create Program
5.47
Create/Edit Role
5.48
Create/Edit Schedule
5.49
Create/Edit Sequence
5.50
Create SQL File
5.51
Create/Edit Synonym
5.52
Create Table (quick creation)
5.53
Create/Edit Table (with advanced options)
5.54
Storage Options
5.55
Create/Edit Tablespace
5.56
Create Trigger
5.57
Create Type (User-Defined)
5.58
Create/Edit User
5.59
Create/Edit User Defined Report
5.60
Create/Edit User Defined Report Folder
5.61
Create/Edit View
5.62
Create XML Schema
5.63
Color Palette and Custom Colors
5.64
Configure Extension
5.65
Configure File Type Associations
5.66
Copy Columns
5.67
Custom Filters
5.68
Data Pump Export
5.69
Data Pump Import
5.70
Database Copy
5.71
Database Differences
5.72
Database Export (Unload Database Objects and Data)
5.73
DDL Panel for Creating or Editing an Object
5.74
Debugger - Attach to JPDA
5.75
Deploy or Import Application
5.76
Deploy Objects
5.77
Describe Object Window
5.78
Edit/View Value (Data or Table Column)
5.79
Enter Bind Values
5.80
Erase from Disk
5.81
Error Writing to Export File
5.82
Export Error
5.83
Export Data
5.84
External Locator Configuration
5.85
External Tools
5.86
Create/Edit External Tool
5.87
Choose Offline Options
5.88
Edit Font Location
5.89
Edit Header or Footer (PDF Formatting)
5.90
Edit Join
5.91
Feature Missing
5.92
Feature Required
5.93
File Processing
5.94
Filter
5.95
Filter Object Types
5.96
Filter Schemas
5.97
Filter Error
5.98
Find/Highlight
5.99
Insert Macro
5.100
Externally Modified Files
5.101
Find/Replace Text
5.102
Find Result
5.103
Format Properties
5.104
Generate Patch
5.105
Go to Bookmark
5.106
Go to Line Number
5.107
Go to Line Number: Error
5.108
History
5.109
Import to CVS
5.110
Invalid Database Version
5.111
Load Keyboard Scheme
5.112
Log In to CVS
5.113
Maintain Spatial Metadata
5.114
Manage Columns
5.115
Modify Value
5.116
Data Move Details
5.117
New Procedure (Refactoring)
5.118
No Lock
5.119
No Object Found
5.120
No Object Selected
5.121
Object Preferences
5.122
Offline Generation Error - Destination Directory
5.123
Open File
5.124
Oracle-Only Report
5.125
Oracle Proxy Authentication
5.126
Paste
5.127
Privilege Warning for Migration
5.128
Recent Files
5.129
Create Repository
5.130
Delete or Truncate Repository
5.131
Capture Microsoft Access Exporter XML
5.132
Rename Local Variable
5.133
Rename Tab
5.134
Rename Procedure
5.135
Select Current Repository
5.136
Cannot Capture Table
5.137
Report Panel
5.138
Reset Expired Password (Enter New Password)
5.139
Revision Lister
5.140
Run/Debug/Profile PL/SQL
5.141
Create/Edit Breakpoint
5.142
Save/Save As, or Select File
5.143
Save Files
5.144
Unable to Save Files
5.145
Save Style Settings
5.146
Schema Differences Source or Destination Error
5.147
Script Execution Failed
5.148
Script Generation Complete
5.149
Set Data Mapping
5.150
Add/Edit Rule
5.151
Set Encoding
5.152
Set Pause Continue
5.153
Shared Wizard Pages
5.153.1
Types
5.153.2
Specify Objects
5.153.3
Data
5.153.4
Summary
5.154
Sign In (checking for updates)
5.155
Single Record View
5.156
Save Snippet (User-Defined)
5.157
Edit Snippets (User-Defined)
5.158
Show SQL
5.159
Start Date, End Date, Repeat Interval, Comments (Scheduler)
5.160
Subversion: Add Property
5.161
Subversion: Add to Source Control
5.162
Subversion: Apply Patch
5.163
Subversion: Branch/Tag
5.164
Subversion: Check Out from Subversion
5.165
Subversion: Commit Resources
5.166
Subversion: Commit Working Copy
5.167
Subversion: Confirm Checkout
5.168
Subversion: Create Remote Directory
5.169
Subversion: Create Subversion Repository
5.170
Subversion: Create/Edit Subversion Connection
5.171
Subversion: Delete Resources
5.172
Subversion: Edit Configuration File
5.173
Subversion: Export Files
5.174
Subversion: Export Subversion Connections
5.175
Subversion: Ignore
5.176
Subversion: Import Subversion Connections
5.177
Subversion: Import to Subversion
5.178
Subversion: Lock Resources
5.179
Subversion: Merge
5.180
Subversion: Pending Changes
5.181
Subversion: Properties
5.182
Subversion: Remove from Subversion
5.183
Subversion: Repository Browser
5.184
Subversion: Revert Local Changes
5.185
Subversion: Switch
5.186
Subversion: Unlock Resources
5.187
Subversion: Update Resources
5.188
Subversion: Update Working Copy
5.189
Subversion: Versioning Properties
5.190
Third-Party Database Objects
5.191
Unable to Connect
5.192
Unable to Open File
5.193
Unit Testing: Action Required
5.194
Unit Testing: Add Category
5.195
Unit Testing: Add Data Type
5.196
Unit Testing: Add Item to Library
5.197
Unit Testing: Add Test Implementation
5.198
Unit Testing: Add Test Suite
5.199
Unit Testing: Add Tests or Suites to a Suite
5.200
Unit Testing: Copy or Rename Unit Test
5.201
Unit Testing: Create Unit Test
5.202
Unit Testing: Manage Users
5.203
Unit Testing: Rename Test Implementation
5.204
Unit Testing: Result of Operation
5.205
Unit Testing: Synchronize Unit Test
5.206
Unsupported Database Version
5.207
Validate Geometry
5.208
View Whole Value
5.209
Windows
5.210
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 Multi-line 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.