Contents

Beta Draft

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 PL/SQL Compiler
  • 1.12.10 PL/SQL Debugger
  • 1.12.11 SQL*Plus
  • 1.12.12 SQL Formatter
  • 1.12.13 Web Browser and Proxy
• 1.13 Location of User-Related Information
• 1.14 Using the Help
• 1.15 For More Information

2 Tutorial: Creating Objects for a Small Database

• 2.1 Creating a Table (BOOKS)
• 2.2 Creating a Table (PATRONS)
• 2.3 Creating a Table (TRANSACTIONS)
• 2.4 Creating a Sequence
• 2.5 Creating a View
• 2.6 Creating a PL/SQL Procedure
• 2.7 Debugging a PL/SQL Procedure
• 2.8 Using the SQL Worksheet for Queries
• 2.9 Script for Creating and Using the Library Tutorial Objects

3 Dialog Boxes for Creating/Editing Objects

• 3.1 Add Extension
• 3.2 Check for Updates
• 3.3 Choose Directory
• 3.4 Create/Edit New Object
• 3.5 Create/Edit/Select Database Connection
• 3.6 Select Connection
• 3.7 Connection Information
• 3.8 No Connection Found
• 3.9 Select Library
• 3.10 Create Library
• 3.11 Export/Import Connection Descriptors
• 3.12 Create/Edit Database Link
• 3.13 Create/Edit Index
• 3.14 Create/Edit Materialized View Log
• 3.15 Create PL/SQL Package
• 3.16 Create PL/SQL Subprogram (Function or Procedure)
• 3.17 Create/Edit Sequence
• 3.18 Create/Edit Synonym
• 3.19 Create Table (quick creation)
• 3.20 Create/Edit Table (with advanced options)
• 3.21 Create Trigger
• 3.22 Create Type (User-Defined)
• 3.23 Create/Edit User
• 3.24 Create/Edit User Defined Report
• 3.25 Create/Edit User Defined Report Folder
• 3.26 Create/Edit View
• 3.27 Create XML Schema
• 3.28 Configure File Type Associations
• 3.29 DDL Panel for Creating or Editing an Object
• 3.30 Debugger - Attach to JPDA
• 3.31 Describe Object Window
• 3.32 Edit Value (Table Column Data)
• 3.33 Enter Bind Values
• 3.34 Export (Selected Objects or Types of Objects)
• 3.35 Export Error
• 3.36 Export Table Data
• 3.37 External Tools
• 3.38 Create/Edit External Tool
• 3.39 Filter
• 3.40 Insert Macro
• 3.41 Externally Modified Files
• 3.42 Filter Object Types
• 3.43 Filter Schemas
• 3.44 Find/Replace Text
• 3.45 Go to Line Number
• 3.46 Go to Line Number: Error
• 3.47 Load Preset Key Mappings
• 3.48 Modify Value
• 3.49 Open File
• 3.50 Query Builder
• 3.51 Recent Files
• 3.52 Run/Debug PL/SQL
• 3.53 Create/Edit Breakpoint
• 3.54 Save/Save As
• 3.55 Save Files
• 3.56 Unable to Save Files
• 3.57 Save Style Settings
• 3.58 Schema Differences
• 3.59 Set Pause Continue
• 3.60 Sign In (checking for updates)
• 3.61 Single Record View
• 3.62 Save Snippet (User-Defined)
• 3.63 Edit Snippets (User-Defined)
• 3.64 SQL History List
• 3.65 SQL*Plus Location
• 3.66 Unable to Open File

Index