Skip Headers
Oracle® Database SQL Developer User's Guide
Release 1.1
Part Number B31695-04
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
List of Figures
List of Tables
Title and Copyright Information
Preface
Audience
Documentation 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.3
Database Objects
1.3.1
Database Links (Public and Private)
1.3.2
Directories
1.3.3
Functions
1.3.4
Indexes
1.3.5
Materialized Views
1.3.6
Materialized View Logs
1.3.7
Packages
1.3.8
Procedures
1.3.9
Recycle Bin
1.3.10
Sequences
1.3.11
Synonyms (Public and Private)
1.3.12
Tables
1.3.13
Triggers
1.3.14
Types
1.3.15
Users (Other Users)
1.3.16
Views
1.3.17
XML Schemas
1.4
Database Connections
1.5
Entering and Modifying Data
1.6
Running and Debugging Functions and Procedures
1.6.1
Remote Debugging
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.8
Using SQL*Plus
1.9
Using Snippets to Insert Code Fragments
1.9.1
User-Defined Snippets
1.10
Using DB Object Search to Find Database Objects
1.11
Reports
1.11.1
About Your Database reports
1.11.2
Database Administration reports
1.11.3
Table reports
1.11.4
PL/SQL reports
1.11.5
Security reports
1.11.6
XML reports
1.11.7
Jobs reports
1.11.8
Streams reports
1.11.9
All Objects reports
1.11.10
Data Dictionary reports
1.11.11
User Defined reports
1.11.11.1
User-Defined Report Example: Chart
1.11.11.2
User-Defined Report Example: Dynamic HTML
1.12
SQL Developer Preferences
1.12.1
Environment
1.12.2
Accelerators (Keyboard Shortcuts)
1.12.3
Code Editor
1.12.4
Database
1.12.5
Debugger
1.12.6
Documentation
1.12.7
Extensions
1.12.8
File Types
1.12.9
Migration
1.12.10
PL/SQL Compiler
1.12.11
PL/SQL Debugger
1.12.12
SQL*Plus
1.12.13
SQL Formatter
1.12.14
Web Browser and Proxy
1.13
Location of User-Related Information
1.14
Using the Help
1.15
For More Information
2
Migrating Third-Party Databases
2.1
Migration Quick Start
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.4.3
Using Nonstandard Character Encoding on Windows Systems
2.5
Before You Start Migrating: Source-Specific Information
2.5.1
Before Migrating From Microsoft SQL Server
2.5.2
Before Migrating From Microsoft Access
2.5.2.1
Creating Microsoft Access XML Files
2.5.3
Before Migrating From MySQL
2.6
Capturing the Source Database
2.7
Creating and Customizing the Converted Model
2.7.1
Correcting Errors in the Converted Model
2.7.2
Customizing the Converted Model
2.7.2.1
Modifying the Properties of a Schema Object
2.7.2.2
Working with Tablespaces
2.7.2.3
Changing the Default User Password
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
Testing the Oracle Database
2.10.1
Testing Methodology
2.10.2
Testing the Oracle Database
2.10.2.1
Guidelines for Creating Tests
2.10.2.2
Example of a Unit Test Case
2.11
Deploying the Oracle Database
2.11.1
Choosing a Rollout Strategy
2.11.1.1
Phased Approach
2.11.1.2
Big Bang Approach
2.11.1.3
Parallel Approach
2.11.2
Deploying the Destination Database
2.12
Using Migration Reports
2.13
SQL Developer User Interface for Migration
2.13.1
Migration Menu
2.13.2
Other Menus: Migration Items
2.13.3
Migration Preferences
2.13.4
Migration Log Panes
2.13.5
Using the Translation Scratch Editor
3
Tutorial: Creating Objects for a Small Database
3.1
Creating a Table (BOOKS)
3.2
Creating a Table (PATRONS)
3.3
Creating a Table (TRANSACTIONS)
3.4
Creating a Sequence
3.5
Creating a View
3.6
Creating a PL/SQL Procedure
3.7
Debugging a PL/SQL Procedure
3.8
Using the SQL Worksheet for Queries
3.9
Script for Creating and Using the Library Tutorial Objects
4
Dialog Boxes for Creating/Editing Objects
4.1
Add Extension
4.2
Check for Updates
4.3
Choose Directory
4.4
Create/Edit New Object
4.5
Create/Edit/Select Database Connection
4.6
Select Connection
4.7
Connection Information
4.8
No Connection Found
4.9
Connection Rename Error
4.10
Select Library
4.11
Create Library
4.12
Excel Import Data
4.13
Export/Import Connection Descriptors
4.14
Create/Edit Database Link
4.15
Create/Edit Index
4.16
Create/Edit Materialized View Log
4.17
Create PL/SQL Package
4.18
Create PL/SQL Subprogram (Function or Procedure)
4.19
Create/Edit Sequence
4.20
Create SQL File
4.21
Create/Edit Synonym
4.22
Create Table (quick creation)
4.23
Create/Edit Table (with advanced options)
4.24
Create Trigger
4.25
Create Type (User-Defined)
4.26
Create/Edit User
4.27
Create/Edit User Defined Report
4.28
Create/Edit User Defined Report Folder
4.29
Create/Edit View
4.30
Create XML Schema
4.31
Configure File Type Associations
4.32
DDL Panel for Creating or Editing an Object
4.33
Debugger - Attach to JPDA
4.34
Describe Object Window
4.35
Edit Value (Table Column Data)
4.36
Enter Bind Values
4.37
Export (Selected Objects or Types of Objects)
4.38
Export: Advanced Data Filter
4.39
Export Error
4.40
Export Table Data
4.41
External Tools
4.42
Create/Edit External Tool
4.43
Filter
4.44
Insert Macro
4.45
Externally Modified Files
4.46
Filter Object Types
4.47
Filter Schemas
4.48
Find/Replace Text
4.49
Generate Oracle DDL
4.50
Generate Offline Data Move Files
4.51
Go to Line Number
4.52
Go to Line Number: Error
4.53
Load Preset Key Mappings
4.54
Modify Value
4.55
Data Move Details
4.56
Open File
4.57
Query Builder
4.58
Recent Files
4.59
Create Repository
4.60
Delete or Truncate Repository
4.61
Capture Microsoft Access Exporter XML
4.62
Select Current Repository
4.63
Run/Debug PL/SQL
4.64
Create/Edit Breakpoint
4.65
Save/Save As
4.66
Save Files
4.67
Unable to Save Files
4.68
Save Style Settings
4.69
Schema Differences
4.70
Schema Differences Source or Destination Error
4.71
Set Data Mapping
4.72
Add/Edit Rule
4.73
Set Pause Continue
4.74
Sign In (checking for updates)
4.75
Single Record View
4.76
Save Snippet (User-Defined)
4.77
Edit Snippets (User-Defined)
4.78
SQL History List
4.79
SQL*Plus Location
4.80
Unable to Open File
Index