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/Edit Synonym
• 4.21 Create Table (quick creation)
• 4.22 Create/Edit Table (with advanced options)
• 4.23 Create Trigger
• 4.24 Create Type (User-Defined)
• 4.25 Create/Edit User
• 4.26 Create/Edit User Defined Report
• 4.27 Create/Edit User Defined Report Folder
• 4.28 Create/Edit View
• 4.29 Create XML Schema
• 4.30 Configure File Type Associations
• 4.31 DDL Panel for Creating or Editing an Object
• 4.32 Debugger - Attach to JPDA
• 4.33 Describe Object Window
• 4.34 Edit Value (Table Column Data)
• 4.35 Enter Bind Values
• 4.36 Export (Selected Objects or Types of Objects)
• 4.37 Export: Advanced Data Filter
• 4.38 Export Error
• 4.39 Export Table Data
• 4.40 External Tools
• 4.41 Create/Edit External Tool
• 4.42 Filter
• 4.43 Insert Macro
• 4.44 Externally Modified Files
• 4.45 Filter Object Types
• 4.46 Filter Schemas
• 4.47 Find/Replace Text
• 4.48 Generate Oracle DDL
• 4.49 Generate Offline Data Move Files
• 4.50 Go to Line Number
• 4.51 Go to Line Number: Error
• 4.52 Load Preset Key Mappings
• 4.53 Modify Value
• 4.54 Data Move Details
• 4.55 Open File
• 4.56 Query Builder
• 4.57 Recent Files
• 4.58 Create Repository
• 4.59 Delete or Truncate Repository
• 4.60 Capture Microsoft Access Exporter XML
• 4.61 Select Current Repository
• 4.62 Run/Debug PL/SQL
• 4.63 Create/Edit Breakpoint
• 4.64 Save/Save As
• 4.65 Save Files
• 4.66 Unable to Save Files
• 4.67 Save Style Settings
• 4.68 Schema Differences
• 4.69 Schema Differences Source or Destination Error
• 4.70 Set Data Mapping
• 4.71 Add/Edit Rule
• 4.72 Set Pause Continue
• 4.73 Sign In (checking for updates)
• 4.74 Single Record View
• 4.75 Save Snippet (User-Defined)
• 4.76 Edit Snippets (User-Defined)
• 4.77 SQL History List
• 4.78 SQL*Plus Location
• 4.79 Unable to Open File

Index