1/11
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
Database Links (Public and Private)
1.3.4
Directories
1.3.5
Editions
1.3.6
Functions
1.3.7
Indexes
1.3.8
Java Sources
1.3.9
Jobs
1.3.10
Materialized Views
1.3.11
Materialized View Logs
1.3.12
Packages
1.3.13
Procedures
1.3.14
Queues
1.3.15
Queue Tables
1.3.16
Recycle Bin
1.3.17
Replication Schemes (Oracle TimesTen In-Memory Database)
1.3.18
Sequences
1.3.19
Synonyms (Public and Private)
1.3.20
Tables
1.3.20.1
Flashback Table Support
1.3.21
Triggers
1.3.22
Types
1.3.23
Users (Other Users)
1.3.24
Views
1.3.25
XML DB Repository
1.3.26
XML Schemas
1.3.27
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
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 CVS and SQL Developer
1.10.1.1
Pending Changes (CVS)
1.10.2
About Subversion and SQL Developer
1.11
SQL Developer Reports
1.11.1
About Your Database reports
1.11.2
All Objects reports
1.11.3
Application Express reports
1.11.4
ASH and AWR reports
1.11.5
Charts reports
1.11.6
Database Administration reports
1.11.7
Data Dictionary reports
1.11.8
Jobs reports
1.11.9
PL/SQL reports
1.11.10
Security reports
1.11.11
Streams reports
1.11.12
Table reports
1.11.13
XML reports
1.11.14
Migration reports
1.11.15
User Defined reports
1.11.15.1
User-Defined Report Example: Chart
1.11.15.2
User-Defined Report Example: Dynamic HTML
1.12
SQL Developer Preferences
1.12.1
Environment
1.12.2
Code Editor
1.12.3
Compare and Merge
1.12.4
Database
1.12.5
Debugger
1.12.6
Extensions
1.12.7
External Editor
1.12.8
File Types
1.12.9
Global Ignore List
1.12.10
Migration
1.12.11
Mouseover Popups
1.12.12
Shortcut Keys (Accelerator Keys)
1.12.13
Unit Test Parameters
1.12.14
Versioning
1.12.15
Web Browser and Proxy
1.13
Location of User-Related Information
1.14
Data Modeler Viewer (Read-Only)
1.15
Oracle TimesTen In-Memory Database Support
1.16
Using the Help
1.17
Tip of the Day
1.17.1
SQL History Shortcuts
1.17.2
Unshared Worksheets
1.17.3
SQL Worksheet Bookmarks
1.17.4
Formatted Display of SQL Trace (.trc) Files
1.17.5
Folders for Organizing Connections
1.17.6
Third-Party Databases and SQL Developer
1.17.7
Debugger Ports and Firewalls
1.17.8
Viewing Multiple Tables
1.17.9
Customizing SQL Developer Appearance
1.17.10
Maximizing Tab Panes
1.17.11
Default Path for Running Scripts
1.17.12
Shutting Down and Restarting the Database
1.17.13
Feature Requests
1.17.14
Discussion Forum
1.17.15
Help Text Font Size
1.17.16
Procedure and Function Signatures
1.17.17
Type-Ahead in Navigators
1.17.18
Extended Paste
1.17.19
Closing Tabbed Windows Using the Mouse Wheel
1.17.20
Go to Last Edit Location
1.17.21
Closing Tabbed Windows Using the Context Menu
1.17.22
List of All Open Windows
1.17.23
Go to Subprogram Implementation from Package Window
1.17.24
Select Multiple Table or Column Names in Completion Insight
1.18
For More Information
2
Migrating Third-Party Databases
2.1
Migration Quick Start
2.1.1
Standard Migration
2.1.2
Quick Migration
2.2
Overview of Migration
2.2.1
How Migration Works
2.2.2
Migration Implemented as SQL Developer Extensions
2.3
Preparing a Migration Plan
2.3.1
Task 1: Determining the Requirements of the Migration Project
2.3.2
Task 2: Estimating Workload
2.3.3
Task 3: Analyzing Operational Requirements
2.3.4
Task 4: Analyzing the Application
2.3.5
Task 5: Planning the Migration Project
2.4
Before You Start Migrating: General Information
2.4.1
Creating a Database User for the Migration Repository
2.4.2
Requirements for Creating the Destination Oracle Objects
2.5
Before You Start Migrating: Source-Specific Information
2.5.1
Before Migrating From IBM DB2
2.5.2
Before Migrating From Microsoft SQL Server or Sybase Adaptive Server
2.5.3
Before Migrating From Microsoft Access
2.5.3.1
Creating Microsoft Access XML Files
2.5.4
Before Migrating From MySQL
2.5.5
Before Migrating From Teradata
2.6
Capturing the Source Database
2.6.1
Online Capture
2.6.2
Offline Capture
2.6.2.1
IBM DB2 Offline Capture Notes
2.7
Creating and Customizing the Converted Model
2.7.1
Correcting Errors in the Converted Model
2.8
Generating the DDL for the Oracle Schema Objects
2.9
Migrating the Data
2.9.1
Transferring the Data Offline
2.9.1.1
Creating Data Files From Microsoft SQL Server or Sybase Adaptive Server
2.9.1.2
Creating Data Files From Microsoft Access
2.9.1.3
Creating Data Files From MySQL
2.9.1.4
Populating the Destination Database Using the Data Files
2.10
Making Queries Case Insensitive
2.11
Testing the Oracle Database
2.11.1
Testing Methodology
2.11.2
Testing the Oracle Database
2.11.2.1
Guidelines for Creating Tests
2.11.2.2
Example of a Unit Test Case
2.12
Deploying the Oracle Database
2.12.1
Choosing a Rollout Strategy
2.12.1.1
Phased Approach
2.12.1.2
Big Bang Approach
2.12.1.3
Parallel Approach
2.12.2
Deploying the Destination Database
2.13
Using Migration Reports
2.14
SQL Developer User Interface for Migration
2.14.1
Migration Menu
2.14.2
Other Menus: Migration Items
2.14.3
Migration Preferences
2.14.4
Migration Log Panes
2.14.5
Using the Translation Scratch Editor
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 for Seed Data
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
Using the Command-Line Interface
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
Dialog Boxes for Creating/Editing Objects
5.1
Add Extension
5.2
Change Type
5.3
Check for Updates
5.4
Check Out from CVS
5.5
Choose Directory
5.6
Configure Component Palette
5.7
Create Palette Page
5.8
Confirm Drop Application
5.9
Confirm Running SQL
5.10
Connection Has Uncommitted Changes
5.11
Create New Object
5.12
Create/Edit CVS Connection
5.13
Create/Edit/Select Database Connection
5.14
Rename Model (Migration)
5.15
Rename Database Item (Migration)
5.16
Select Connection
5.17
Connection Information
5.18
No Connection Found
5.19
Connection Rename Error
5.20
New Folder (Connections)
5.21
Continue After Pause
5.22
Select Library
5.23
Create Library
5.24
Import Data
5.25
Export/Import Connection Descriptors
5.26
Create/Edit Database Link
5.27
Create/Edit Index
5.28
Create Filter
5.29
Create/Edit Materialized View Log
5.30
Create PL/SQL Package
5.31
Create PL/SQL Subprogram (Function or Procedure)
5.32
Create/Edit Sequence
5.33
Create SQL File
5.34
Create/Edit Synonym
5.35
Create Table (quick creation)
5.36
Create/Edit Table (with advanced options)
5.37
Storage Options
5.38
Create Trigger
5.39
Create Type (User-Defined)
5.40
Create/Edit User
5.41
Create/Edit User Defined Report
5.42
Create/Edit User Defined Report Folder
5.43
Create/Edit View
5.44
Create XML Schema
5.45
Configure Extension
5.46
Configure File Type Associations
5.47
Copy Columns
5.48
Custom Filters
5.49
Database Copy (Schema Objects)
5.50
Database Schema Differences
5.51
DDL Panel for Creating or Editing an Object
5.52
Debugger - Attach to JPDA
5.53
Deploy or Import Application
5.54
Describe Object Window
5.55
Edit/View Value (Table Column or Other Data)
5.56
Enter Bind Values
5.57
Erase from Disk
5.58
Error Writing to Export File
5.59
Export (Database Objects and Data)
5.60
Export: Advanced Data Filter
5.61
Export Error
5.62
Export Data
5.63
Export Table Data
5.64
External Locator Configuration
5.65
External Tools
5.66
Create/Edit External Tool
5.67
Choose Offline Options
5.68
Edit Join
5.69
Feature Required
5.70
Filter
5.71
Insert Macro
5.72
Externally Modified Files
5.73
Filter Object Types
5.74
Filter Schemas
5.75
Filter Error
5.76
Find/Replace Text
5.77
Find Result
5.78
Format Properties
5.79
Generate Oracle DDL
5.80
Generate Offline Data Move Files
5.81
Generate Patch
5.82
Go to Bookmark
5.83
Go to Line Number
5.84
Go to Line Number: Error
5.85
Import to CVS
5.86
Load Keyboard Scheme
5.87
Log In to CVS
5.88
Manage Columns
5.89
Modify Value
5.90
Data Move Details
5.91
New Procedure (Refactoring)
5.92
No Object Found
5.93
No Object Selected
5.94
Object Preferences
5.95
Open File
5.96
Oracle-Only Report
5.97
Oracle Proxy Authentication
5.98
Paste
5.99
Privilege Warning for Migration
5.100
Query Builder
5.101
Recent Files
5.102
Create Repository
5.103
Delete or Truncate Repository
5.104
Capture Microsoft Access Exporter XML
5.105
Rename Local Variable
5.106
Rename Procedure
5.107
Select Current Repository
5.108
Cannot Capture Table
5.109
Reset Expired Password (Enter New Password)
5.110
Revision Lister
5.111
Run/Debug/Profile PL/SQL
5.112
Create/Edit Breakpoint
5.113
Save/Save As, or Select File
5.114
Save Files
5.115
Unable to Save Files
5.116
Save Style Settings
5.117
Schema Differences Source or Destination Error
5.118
Script Execution Failed
5.119
Script Generation Complete
5.120
Set Data Mapping
5.121
Add/Edit Rule
5.122
Set Encoding
5.123
Set Pause Continue
5.124
Sign In (checking for updates)
5.125
Single Record View
5.126
Save Snippet (User-Defined)
5.127
Edit Snippets (User-Defined)
5.128
Subversion: Add Property
5.129
Subversion: Add to Source Control
5.130
Subversion: Apply Patch
5.131
Subversion: Branch/Tag
5.132
Subversion: Check Out from Subversion
5.133
Subversion: Commit Resources
5.134
Subversion: Commit Working Copy
5.135
Subversion: Confirm Checkout
5.136
Subversion: Create Remote Directory
5.137
Subversion: Create Subversion Repository
5.138
Subversion: Create/Edit Subversion Connection
5.139
Subversion: Edit Configuration File
5.140
Subversion: Export Files
5.141
Subversion: Export Subversion Connections
5.142
Subversion: History
5.143
Subversion: Ignore
5.144
Subversion: Import Subversion Connections
5.145
Subversion: Import to Subversion
5.146
Subversion: Lock Resources
5.147
Subversion: Merge
5.148
Subversion: Pending Changes
5.149
Subversion: Properties
5.150
Subversion: Remove from Subversion
5.151
Subversion: Repository Browser
5.152
Subversion: Revert Local Changes
5.153
Subversion: Switch
5.154
Subversion: Unlock Resources
5.155
Subversion: Update Resources
5.156
Subversion: Update Working Copy
5.157
Subversion: Versioning Properties
5.158
Third-Party Database Objects
5.159
Unable to Connect
5.160
Unable to Open File
5.161
Unit Testing: Action Required
5.162
Unit Testing: Add Category
5.163
Unit Testing: Add Data Type
5.164
Unit Testing: Add Item to Library
5.165
Unit Testing: Add Test Implementation
5.166
Unit Testing: Add Test Suite
5.167
Unit Testing: Add Tests to Suite
5.168
Unit Testing: Copy or Rename Unit Test
5.169
Unit Testing: Create Unit Test
5.170
Unit Testing: Manage Users
5.171
Unit Testing: Result of Operation
5.172
Unsupported Database Version
5.173
Windows
Index
Scripting on this page enhances content navigation, but does not change the content in any way.