1/15

Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Product Accessibility
• Related Documents
• Conventions
• Third-Party License Information
  • Antlr 3.1.3
  • Batik Version 1.7
  • Bouncy Castle Crypto API 1.45
  • JGoodies Looks 1.3.1
  • JXLayer 4.0
  • Log4j 1.2.9
  • POI 2.5.1
  • Regular Expression Package 1.3

1 SQL Developer Concepts and Usage

• 1.1 About SQL Developer
• 1.2 Installing and Getting Started with SQL Developer
• 1.3 SQL Developer User Interface
  • 1.3.1 Menus for SQL Developer
  • 1.3.2 Restoring the Original "Look and Feel"
• 1.4 Database Objects
  • 1.4.1 Applications (Application Express 3.0.1 and Later)
  • 1.4.2 Cache Groups (Oracle TimesTen In-Memory Database)
  • 1.4.3 Chains
  • 1.4.4 Credentials
  • 1.4.5 Database Destinations
  • 1.4.6 Database Links (Public and Private)
  • 1.4.7 Destination Groups
  • 1.4.8 Directories
  • 1.4.9 Editions
  • 1.4.10 File Watchers
  • 1.4.11 Functions
  • 1.4.12 Indexes
  • 1.4.13 Java Sources
  • 1.4.14 Jobs
  • 1.4.15 Job Classes
  • 1.4.16 Operators
  • 1.4.17 Materialized Views
  • 1.4.18 Materialized View Logs
  • 1.4.19 Multitenant Container Database (CDB)
  • 1.4.20 Packages
  • 1.4.21 Procedures
  • 1.4.22 Programs
  • 1.4.23 Queues
  • 1.4.24 Queue Tables
  • 1.4.25 Recycle Bin
  • 1.4.26 Replication Schemes (Oracle TimesTen In-Memory Database)
  • 1.4.27 Schedules
  • 1.4.28 Sequences
  • 1.4.29 Synonyms (Public and Private)
  • 1.4.30 Tables
    • 1.4.30.1 Flashback Table Support
  • 1.4.31 Triggers
  • 1.4.32 Types
  • 1.4.33 Users (Other Users)
  • 1.4.34 Views
  • 1.4.35 Window Groups
  • 1.4.36 Windows
  • 1.4.37 XML DB Repository
  • 1.4.38 XML Schemas
  • 1.4.39 Captured and Converted Database Objects (for Migration)
• 1.5 Database Connections
  • 1.5.1 Using Folders to Group Connections
  • 1.5.2 Sharing of Connections
  • 1.5.3 Advanced Security for JDBC Connection to the Database
  • 1.5.4 Connections with Operating System (OS) Authentication
  • 1.5.5 Connections with Proxy Authentication
  • 1.5.6 Connections with SSH Authentication
• 1.6 Entering and Modifying Data
• 1.7 Running and Debugging Functions and Procedures
  • 1.7.1 Using Bookmarks When Editing Functions and Procedures
  • 1.7.2 Remote Debugging
  • 1.7.3 Displaying SQL Trace (.trc) Files
  • 1.7.4 Using the PL/SQL Hierarchical Profiler
  • 1.7.5 Setting Expression Watches
• 1.8 Using the SQL Worksheet
  • 1.8.1 SQL*Plus Statements Supported and Not Supported in SQL Worksheet
  • 1.8.2 Script Runner
  • 1.8.3 Execution Plan
  • 1.8.4 Autotrace Pane
  • 1.8.5 DBMS Output Pane
  • 1.8.6 OWA Output Pane
  • 1.8.7 SQL History
  • 1.8.8 Query Builder
  • 1.8.9 Command-Line Interface for SQL Formatting
  • 1.8.10 SQL Worksheet "Hints" for Formatting Output
  • 1.8.11 Gauges: In the SQL Worksheet and User-Defined Reports
  • 1.8.12 Entering OLAP DML Statements in the SQL Worksheet
• 1.9 Using Snippets to Insert Code Fragments
  • 1.9.1 User-Defined Snippets
• 1.10 Finding Database Objects
• 1.11 Using Recent Objects
• 1.12 Using Versioning
  • 1.12.1 About Subversion and SQL Developer
  • 1.12.2 Pending Changes
• 1.13 Using DBA Features in SQL Developer
  • 1.13.1 Container Database (CDB)
  • 1.13.2 Database Configuration
    • 1.13.2.1 Initialization Parameters
    • 1.13.2.2 Automatic Undo Management
    • 1.13.2.3 Current Database Properties
    • 1.13.2.4 Restore Points
    • 1.13.2.5 View Database Feature Usage
  • 1.13.3 Database Status
    • 1.13.3.1 Status
    • 1.13.3.2 DB Instance
    • 1.13.3.3 Instance Viewer
  • 1.13.4 Data Guard
  • 1.13.5 Data Pump
    • 1.13.5.1 Export Jobs
    • 1.13.5.2 Import Jobs
  • 1.13.6 Oracle Sharding
  • 1.13.7 Performance
    • 1.13.7.1 Snapshots
    • 1.13.7.2 Baselines
    • 1.13.7.3 Baseline Templates
    • 1.13.7.4 Automatic Database Diagnostic Monitor (ADDM)
    • 1.13.7.5 ASH (Active Session History) Report Viewer
    • 1.13.7.6 AWR (Automatic Workload Repository)
  • 1.13.8 RMAN Backup/Recovery
    • 1.13.8.1 Backup Jobs
    • 1.13.8.2 Backup Sets
    • 1.13.8.3 Image Copies
    • 1.13.8.4 RMAN Settings
    • 1.13.8.5 Scheduled RMAN Actions
    • 1.13.8.6 Using Action Jobs
  • 1.13.9 Resource Manager
    • 1.13.9.1 Consumer Group Mappings
    • 1.13.9.2 Consumer Groups
    • 1.13.9.3 Plans
    • 1.13.9.4 Settings
    • 1.13.9.5 Statistics
  • 1.13.10 SQL Translator FrameWork
    • 1.13.10.1 SQL Translator Profiles
    • 1.13.10.2 SQL Translators
  • 1.13.11 Scheduler
    • 1.13.11.1 Global Attributes
    • 1.13.11.2 Job Classes
    • 1.13.11.3 External Destinations
  • 1.13.12 Security
    • 1.13.12.1 Audit Settings
    • 1.13.12.2 Profiles
    • 1.13.12.3 Roles
    • 1.13.12.4 Users
  • 1.13.13 Storage
    • 1.13.13.1 Archive Logs
    • 1.13.13.2 Control Files
    • 1.13.13.3 Datafiles
    • 1.13.13.4 Redo Log Groups
    • 1.13.13.5 Rollback Segments
    • 1.13.13.6 Tablespaces
    • 1.13.13.7 Temporary Tablespace Groups
  • 1.13.14 Tuning
    • 1.13.14.1 Real Time SQL Monitor
• 1.14 Scheduling Jobs Using SQL Developer
  • 1.14.1 Scheduler Design Editor
• 1.15 Using the Cart
  • 1.15.1 Cart Versus Database Export Wizard
• 1.16 Spatial Support in SQL Developer
  • 1.16.1 Context Menu Operations on Spatial Data and Metadata
  • 1.16.2 Map Visualization of Spatial Data
    • 1.16.2.1 Visualizing Geometries by Creating and Executing a Query
    • 1.16.2.2 Visualizing Geometries from the Table Data Grid
• 1.17 Change Manager Support in SQL Developer
  • 1.17.1 Change Plan Administrators and Developers
  • 1.17.2 Developing Change Plans with SQL Developer
    • 1.17.2.1 Creating a Repository Connection
    • 1.17.2.2 Creating and Deleting Change Plans
    • 1.17.2.3 Adding and Updating Change Items
    • 1.17.2.4 Using Change Plans to Capture Change in SQL Developer
  • 1.17.3 Change Manager Actions to Perform with Enterprise Manager
    • 1.17.3.1 Creating Change Plans from Change Manager Schema Comparisons
    • 1.17.3.2 Deploying Change Plans
• 1.18 Apache Hadoop Connectors Support in SQL Developer
  • 1.18.1 Copy to Hadoop: Overview and Requirements
  • 1.18.2 Oracle Loader for Hadoop: Overview and Requirements
  • 1.18.3 Oracle SQL Connector for HDFS: Overview and Requirements
• 1.19 SQL Developer Reports
  • 1.19.1 Bind Variables for Reports
  • 1.19.2 About Your Database reports
  • 1.19.3 All Objects reports
  • 1.19.4 Application Express reports
  • 1.19.5 ASH and AWR reports
  • 1.19.6 Charts reports
  • 1.19.7 Database Administration reports
  • 1.19.8 Data Dictionary reports
  • 1.19.9 Scheduler reports
  • 1.19.10 PL/SQL reports
  • 1.19.11 Security reports
  • 1.19.12 Streams reports
  • 1.19.13 Table reports
    • 1.19.13.1 Quality Assurance reports
  • 1.19.14 XML reports
  • 1.19.15 Data Modeler reports
  • 1.19.16 User Defined reports
    • 1.19.16.1 User-Defined Report Example: Chart
    • 1.19.16.2 User-Defined Report Example: Dynamic HTML
• 1.20 SQL Developer Preferences
  • 1.20.1 Environment
  • 1.20.2 Change Management Parameters
  • 1.20.3 Code Editor
  • 1.20.4 Compare and Merge
  • 1.20.5 Database
  • 1.20.6 Debugger
  • 1.20.7 External Editor
  • 1.20.8 File Types
  • 1.20.9 Global Ignore List
  • 1.20.10 Migration
  • 1.20.11 Mouse Actions
  • 1.20.12 Shortcut Keys (Accelerator Keys)
  • 1.20.13 SSH (Secure Shell)
  • 1.20.14 Unit Test Parameters
  • 1.20.15 Usage Reporting
  • 1.20.16 Versioning
    • 1.20.16.1 Versioning: Git
    • 1.20.16.2 Versioning: Subversion
    • 1.20.16.3 Versioning: CVS
    • 1.20.16.4 Versioning: Perforce
  • 1.20.17 Web Browser and Proxy
  • 1.20.18 XML Schemas
• 1.21 Location of User-Related Information
• 1.22 Java Development Kit (JDK) Location
• 1.23 Command-Line Interface for SQL Developer
• 1.24 Data Modeler in SQL Developer
• 1.25 Oracle TimesTen In-Memory Database Support
• 1.26 Using the Help
• 1.27 SQL Developer Usage Suggestions
  • 1.27.1 SQL History Shortcuts
  • 1.27.2 Unshared Worksheets
  • 1.27.3 SQL Worksheet Bookmarks
  • 1.27.4 Oracle Data Miner
  • 1.27.5 Formatted Display of SQL Trace (.trc) Files
  • 1.27.6 Keyboard Navigation: Alt + Page Down/Up to Move Among Tabs
  • 1.27.7 Folders for Organizing Connections
  • 1.27.8 Third-Party Databases and SQL Developer
  • 1.27.9 Debugger Ports and Firewalls
  • 1.27.10 Viewing Multiple Tables
  • 1.27.11 Customizing SQL Developer Appearance
  • 1.27.12 Maximizing Tab Panes
  • 1.27.13 Default Path for Running Scripts
  • 1.27.14 Shutting Down and Restarting the Database
  • 1.27.15 Feature Requests
  • 1.27.16 Discussion Forums
  • 1.27.17 Help Text Font Size
  • 1.27.18 Procedure and Function Signatures
  • 1.27.19 Type-Ahead in Navigators
  • 1.27.20 Extended Paste
  • 1.27.21 Closing Tabbed Windows Using the Mouse Wheel
  • 1.27.22 Go to Last Edit Location
  • 1.27.23 Closing Tabbed Windows Using the Context Menu
  • 1.27.24 List of All Open Windows
  • 1.27.25 Go to Subprogram Implementation from Package Window
  • 1.27.26 Select Multiple Table or Column Names in Completion Insight
  • 1.27.27 Startup Time and Automatic Check for Updates
• 1.28 For More Information About SQL Developer

2 SQL Developer: Migrating Third-Party Databases

• 2.1 Migration: Basic Options and Steps
  • 2.1.1 Migrating Using the Migration Wizard
    • 2.1.1.1 Repository
    • 2.1.1.2 Project
    • 2.1.1.3 Source Database
    • 2.1.1.4 Capture
    • 2.1.1.5 Convert
    • 2.1.1.6 Translate
    • 2.1.1.7 Target Database
    • 2.1.1.8 Move Data
    • 2.1.1.9 Summary
  • 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 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 MySQL
    • 2.2.4.4 Before Migrating From Teradata
  • 2.2.5 Capturing the Source Database
    • 2.2.5.1 Offline Capture
      • 2.2.5.1.1 IBM DB2 Offline Capture Notes
  • 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.8.1.1 Creating Data Files From Microsoft SQL Server or Sybase Adaptive Server
      • 2.2.8.1.2 Creating Data Files From MySQL
      • 2.2.8.1.3 Populating the Destination Database Using the Data Files
  • 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.10.2.1 Guidelines for Creating Tests
      • 2.2.10.2.2 Example of a Unit Test Case
  • 2.2.11 Deploying the Oracle Database
    • 2.2.11.1 Choosing a Rollout Strategy
      • 2.2.11.1.1 Phased Approach
      • 2.2.11.1.2 Big Bang Approach
      • 2.2.11.1.3 Parallel Approach
    • 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: Oracle REST Data Services Support

• 3.1 Installing Oracle REST Data Services
• 3.2 Oracle REST Data Services Administration
  • 3.2.1 About Oracle REST Data Services
  • 3.2.2 Oracle REST Data Services Administration Toolbar and Context Menu
  • 3.2.3 Connecting to Oracle REST Data Services
  • 3.2.4 REST Data Services Navigator: Global Settings and Database Settings
    • 3.2.4.1 Connections
    • 3.2.4.2 Default Password
    • 3.2.4.3 ORDS Public User (Database Settings Only)
    • 3.2.4.4 PL/SQL Gateway User (Database Settings Only)
    • 3.2.4.5 APEX REST Users (Database Settings Only)
    • 3.2.4.6 Security
    • 3.2.4.7 Cache Files
    • 3.2.4.8 Environment
    • 3.2.4.9 Excel
  • 3.2.5 REST Data Services Navigator: NoSQL Store Configuration
  • 3.2.6 REST Data Services Navigator: Reports
• 3.3 Automatically Enabling REST Access to a Schema, Table, or View (AutoREST)
• 3.4 REST Development
  • 3.4.1 About RESTful Services
  • 3.4.2 RESTful Services Terminology
  • 3.4.3 RESTful Services Requirements and Setup
  • 3.4.4 REST Data Services in the Connections Navigator
  • 3.4.5 REST Development Pane

4 SQL Developer: Unit Testing

• 4.1 Overview of Unit Testing
• 4.2 SQL Developer User Interface for Unit Testing
  • 4.2.1 Unit Test Submenu
  • 4.2.2 Other Menus: Unit Test Items
  • 4.2.3 Unit Test Preferences
• 4.3 Unit Test Repository
  • 4.3.1 Managing Repository Users and Administrators
• 4.4 Editing and Running a Unit Test
• 4.5 Using a Dynamic Value Query to Create a Unit Test
• 4.6 Using Lookups to Simplify Unit Test Creation
  • 4.6.1 Providing Values for Input Fields
  • 4.6.2 Automatically Creating Implementations
• 4.7 Using Variable Substitution in Validation Actions
• 4.8 Unit Test Library
• 4.9 Unit Test Reports
• 4.10 Exporting and Importing Unit Test Objects
• 4.11 Command-Line Interface for Unit Testing
• 4.12 Unit Testing Best Practices
  • 4.12.1 Strategy
  • 4.12.2 Test Suites
  • 4.12.3 Test Naming
  • 4.12.4 Avoiding Test Naming Clashes
  • 4.12.5 Test Implementations
  • 4.12.6 Library
  • 4.12.7 Lookups
  • 4.12.8 Test and Suite Execution
  • 4.12.9 Reports
• 4.13 Example of Unit Testing (Tutorial)
  • 4.13.1 Create the EMPLOYEES Table
  • 4.13.2 Create the AWARD_BONUS Procedure
  • 4.13.3 Create the Unit Testing Repository
  • 4.13.4 Create a Unit Test
  • 4.13.5 Run the Unit Test
  • 4.13.6 Create and Run an Exception Unit Test
  • 4.13.7 Create a Unit Test Suite
  • 4.13.8 Run the Unit Test Suite

5 SQL Developer Tutorial: Creating Objects for a Small Database

• 5.1 Create a Table (BOOKS)
• 5.2 Create a Table (PATRONS)
• 5.3 Create a Table (TRANSACTIONS)
• 5.4 Create a Sequence
• 5.5 Insert Data into the Tables
• 5.6 Create a View
• 5.7 Create a PL/SQL Procedure
• 5.8 Debug a PL/SQL Procedure
• 5.9 Use the SQL Worksheet for Queries
• 5.10 Script for Creating and Using the Library Tutorial Objects

6 SQL Developer Dialog Boxes and Wizards

• 6.1 Add Extension
• 6.2 Add Schema Error
• 6.3 Advanced Properties (Connections)
  • 6.3.1 Proxy tab
• 6.4 Application Migration
• 6.5 Associate Repository
• 6.6 Cart Error (Objects Not Available)
• 6.7 Change Type
• 6.8 Check for Updates
• 6.9 Choose Directory
• 6.10 Clone PDB to Oracle Cloud
• 6.11 Clone Pluggable Database
• 6.12 Color Palette and Custom Colors
• 6.13 Configure Extension
• 6.14 Configure File Type Associations
• 6.15 Copy Columns
• 6.16 Copy Objects
• 6.17 Copy to Hadoop / Append to Hadoop Table
• 6.18 Copy to Oracle
• 6.19 Component Palette
• 6.20 Component Palette: Configure Component Palette
• 6.21 Component Palette: Create Palette Page
• 6.22 Component Palette: New/Edit Code Snippet
• 6.23 Component Palette: New Section/Rename Section
• 6.24 Confirm Drop Application
• 6.25 Confirm Running SQL
• 6.26 Connection Has Uncommitted Changes
• 6.27 Create New Object
• 6.28 Create/Edit Chain
• 6.29 Create/Edit Credential
• 6.30 Create/Edit/Select Database Connection
  • 6.30.1 Oracle tab
  • 6.30.2 TimesTen tab
  • 6.30.3 Amazon Redshift tab
  • 6.30.4 DB2 tab
  • 6.30.5 Hive tab
  • 6.30.6 JDBC tab
  • 6.30.7 MySQL tab
  • 6.30.8 PostgreSQL tab
  • 6.30.9 SQL Server and Sybase tab
  • 6.30.10 Teradata tab
  • 6.30.11 Creating and Editing Connections
• 6.31 New/Edit Cloud Connection
  • 6.31.1 Advanced Connection Information
• 6.32 New/Edit NoSQL Connection
• 6.33 Rename Model (Migration)
• 6.34 Delete Confirmation
• 6.35 Delete Confirmation (Migration)
• 6.36 Rename Database Item (Migration)
• 6.37 Select Connection
• 6.38 Connection Information
• 6.39 No Connection Found
• 6.40 Connection Rename Error
• 6.41 New Folder (Connections)
• 6.42 Continue After Pause
• 6.43 Select Library
• 6.44 Create Library
• 6.45 CVS: Check Out from CVS
• 6.46 CVS: Create/Edit CVS Connection
• 6.47 CVS: Import to CVS
• 6.48 CVS: Log In to CVS
• 6.49 Data Import Wizard (Load Data)
  • 6.49.1 Data Preview
  • 6.49.2 Import Method
  • 6.49.3 Choose Columns
  • 6.49.4 Column Definition
  • 6.49.5 Finish
• 6.50 Export/Import Connections
  • 6.50.1 Export Connections
  • 6.50.2 Import Connections
• 6.51 Create/Edit Database Destination
• 6.52 Create/Edit Destination Group (Database or External)
• 6.53 Create/Edit Database Link
• 6.54 Create/Edit Index
  • 6.54.1 Definition
  • 6.54.2 Properties
  • 6.54.3 Storage
  • 6.54.4 Partitions
  • 6.54.5 DDL
• 6.55 Create File Watcher
• 6.56 Create Filter
• 6.57 Create Function or Procedure
• 6.58 Create/Edit Job
  • 6.58.1 Job Details
  • 6.58.2 Destination
  • 6.58.3 Job Arguments
  • 6.58.4 Notification
  • 6.58.5 Properties
  • 6.58.6 Summary/SQL
• 6.59 Create/Edit Job Class
• 6.60 Create/Edit Materialized View Log
• 6.61 Create PL/SQL Package
• 6.62 Create Pluggable Database
• 6.63 Create/Edit Program
• 6.64 Create/Edit Role
• 6.65 Create/Edit Schedule
• 6.66 Create/Edit Sequence
• 6.67 Create SQL File
• 6.68 Create/Edit Synonym
• 6.69 Create Table (quick creation)
• 6.70 Create/Edit Table (with advanced options)
  • 6.70.1 Columns pane
  • 6.70.2 Constraints
  • 6.70.3 Primary Key Constraint
  • 6.70.4 Unique Constraints
  • 6.70.5 Foreign Keys Constraints
  • 6.70.6 Check Constraints
  • 6.70.7 Indexes pane
  • 6.70.8 In-Memory pane
  • 6.70.9 Storage pane
  • 6.70.10 Column Sequences pane
  • 6.70.11 Table Properties pane
  • 6.70.12 LOB Parameters pane
  • 6.70.13 Partitioning pane
  • 6.70.14 Subpartition Templates pane
  • 6.70.15 Partition Definitions pane
  • 6.70.16 Index Organized Properties pane
  • 6.70.17 External Table Properties pane
  • 6.70.18 Comment pane
  • 6.70.19 DDL pane
  • 6.70.20 Hive Tables
    • 6.70.20.1 Hive Tables: Partitions
    • 6.70.20.2 Hive Tables: Buckets
    • 6.70.20.3 Hive Tables: Skew
    • 6.70.20.4 Hive Tables: Storage
    • 6.70.20.5 Hive Tables: Table Properties
• 6.71 Storage Options
• 6.72 Create/Edit Tablespace
  • 6.72.1 File Specifications tab
  • 6.72.2 Properties tab
  • 6.72.3 Default Parameters tab
  • 6.72.4 DDL tab
• 6.73 Create Trigger
• 6.74 Create Type (User-Defined)
• 6.75 Create/Edit User
  • 6.75.1 User tab
  • 6.75.2 Granted Roles tab
  • 6.75.3 System Privileges tab
  • 6.75.4 Quotas tab
  • 6.75.5 SQL tab
• 6.76 Create/Edit User Defined Report
• 6.77 Create/Edit User Defined Report Folder
• 6.78 Create/Edit View
  • 6.78.1 SQL Query tab or pane
  • 6.78.2 View Properties or Materialized View Properties pane
  • 6.78.3 DDL tab or pane
  • 6.78.4 Quick-Pick Objects pane
  • 6.78.5 FROM Clause pane
  • 6.78.6 SELECT Clause pane
  • 6.78.7 WHERE Clause pane
  • 6.78.8 GROUP BY Clause pane
  • 6.78.9 HAVING Clause pane
  • 6.78.10 ORDER BY Clause pane
• 6.79 Create Window
• 6.80 Create Window Group
• 6.81 Create XML Document from XML Schema
• 6.82 Create XML Schema
• 6.83 Custom Filters
• 6.84 Customize Toolbars
• 6.85 Data Pump Export
  • 6.85.1 Source page
  • 6.85.2 Tablespaces page
  • 6.85.3 Schemas page
  • 6.85.4 Tables page
  • 6.85.5 Filter page
  • 6.85.6 Table Data page
  • 6.85.7 Options page
  • 6.85.8 Output Files page
  • 6.85.9 Job Schedule page
  • 6.85.10 Summary page
• 6.86 Data Pump Import
  • 6.86.1 Type page
  • 6.86.2 Tablespaces page
  • 6.86.3 Schemas page
  • 6.86.4 Tables page
  • 6.86.5 Filter page
  • 6.86.6 Table Data page
  • 6.86.7 Remapping page
  • 6.86.8 Options page
  • 6.86.9 Job Schedule page
  • 6.86.10 Summary page
• 6.87 Database Copy
  • 6.87.1 Source/Destination page
  • 6.87.2 Object Types page
  • 6.87.3 Select Schemas page
  • 6.87.4 Select Tablespace page
  • 6.87.5 Specify Objects page
  • 6.87.6 Specify Data page
  • 6.87.7 Summary page
• 6.88 Database Differences
  • 6.88.1 Source/Destination page
  • 6.88.2 Types to Diff page
  • 6.88.3 Specify Objects page
  • 6.88.4 Summary page
• 6.89 Database Export (Unload Database Objects and Data)
  • 6.89.1 Source/Destination page
  • 6.89.2 Types to Export page
  • 6.89.3 Specify Objects page
  • 6.89.4 Specify Data page
  • 6.89.5 Export Summary page
• 6.90 DDL Panel for Creating or Editing an Object
• 6.91 Debugger - Attach to JPDA
• 6.92 Deploy or Import Application
• 6.93 Deploy Objects to Cloud
  • 6.93.1 Cloud
  • 6.93.2 Authorization
  • 6.93.3 Transfer
  • 6.93.4 Deploy DDL
  • 6.93.5 Deploy Data
  • 6.93.6 Unsupported Cart Object for Cloud Deployment
  • 6.93.7 Other Errors (Invalid or Missing Entries)
• 6.94 Describe Object Window
• 6.95 Diff Objects
• 6.96 Drop Pluggable Database
• 6.97 Drop REST Services for Schema
• 6.98 Edit/View Value (Data or Table Column)
• 6.99 Enter Bind Values
• 6.100 Erase from Disk
• 6.101 Error Writing to Export File
• 6.102 Export Error
• 6.103 Export Data
• 6.104 Export Objects
• 6.105 Export Resource Module, Privilege, and Role
• 6.106 Export: Unique Names Warning
• 6.107 External Locator Configuration
• 6.108 External Tools
• 6.109 Create/Edit External Tool
  • 6.109.1 Program Options
  • 6.109.2 Display
  • 6.109.3 Integration
  • 6.109.4 Availability
• 6.110 Choose Offline Options
• 6.111 Edit Font Location
• 6.112 Edit Header or Footer (PDF Formatting)
• 6.113 Edit Join
• 6.114 Feature Missing
• 6.115 Feature Required
• 6.116 File Processing
• 6.117 Filter
• 6.118 Filter Object Types
• 6.119 Filter Schemas
• 6.120 Filter Error
• 6.121 Find/Highlight
• 6.122 Git: Add
• 6.123 Git: Add All
• 6.124 Git: Add to .gitignore File
• 6.125 Git: Checkout Revision
• 6.126 Git: Clone from Git
• 6.127 Git: Commit
• 6.128 Git: Commit All
• 6.129 Git: Create Branch
• 6.130 Git: Create Tag
• 6.131 Git: Export Committed Changes
• 6.132 Git: Export Uncommitted Changes
• 6.133 Git: Fetch from Git
• 6.134 Git: Initialize Repository
• 6.135 Git: Merge
• 6.136 Git: Pull from Git
• 6.137 Git: Push to Git
• 6.138 Git: Revert
• 6.139 Insert Macro
• 6.140 Externally Modified Files
• 6.141 Find/Replace Text
• 6.142 Find Result
• 6.143 Format Properties (Advanced Formatting)
• 6.144 Generate Patch
• 6.145 Go to Bookmark
• 6.146 Go to Line Number
• 6.147 Go to Line Number: Error
• 6.148 History
• 6.149 Import Using Oracle Loader for Hadoop
• 6.150 Import Using Oracle SQL Connector for HDFS
• 6.151 Install/Run Oracle REST Data Services
  • 6.151.1 ORDS File Locations
  • 6.151.2 Database Connection
  • 6.151.3 Database Options
  • 6.151.4 Select Tablespace
  • 6.151.5 PL/SQL Gateway
  • 6.151.6 APEX RESTful Services
  • 6.151.7 Run Standalone Mode
  • 6.151.8 ORDS Users
  • 6.151.9 Summary
• 6.152 Install SQL Translator
  • 6.152.1 Installing a Translator and Creating a Profile: Usage Notes
• 6.153 Invalid Database Version
• 6.154 Load Extension
• 6.155 Load Keyboard Scheme
• 6.156 LOB Descriptors
• 6.157 Maintain Spatial Metadata
• 6.158 Manage Columns
• 6.159 Manage Connections (REST)
• 6.160 Manage Features and Updates
• 6.161 Map Connection
• 6.162 Merge Migration Projects
• 6.163 Modify Pluggable State
• 6.164 Modify Value
• 6.165 Data Move Details
• 6.166 New/Edit Change Set
• 6.167 New Procedure (Refactoring)
• 6.168 New/Edit Local or Remote Port Forward
• 6.169 Edit SSH Connection
• 6.170 No Lock
• 6.171 No Object Found
• 6.172 No Object Selected
• 6.173 Object Preferences
• 6.174 Offline Generation Error - Destination Directory
• 6.175 Open File
• 6.176 Oracle-Only Report
• 6.177 Paste
• 6.178 Perforce: Add Files to Perforce
• 6.179 Perforce: Connection
• 6.180 Perforce: Create Changelist
• 6.181 Perforce: Delete Files
• 6.182 Perforce: Login
• 6.183 Perforce: Open Files for Edit
• 6.184 Perforce: Revert Files
• 6.185 Perforce: Sync Files
• 6.186 Perforce: Submit Changelist
• 6.187 Plug In Pluggable Database
• 6.188 Print Preview
• 6.189 Privilege Warning for Migration
• 6.190 Publish to REST
• 6.191 Recent Files
• 6.192 Delete or Truncate Repository
  • 6.192.1 Error Truncating Repository
• 6.193 Rename Local Variable
• 6.194 Rename Tab
• 6.195 Rename Procedure
• 6.196 Repair (Validate) Oracle REST Data Services
• 6.197 REST Data Services Connection
• 6.198 REST Data Services Connection: Authentication Failed
• 6.199 REST Data Services Connection: Remove Connection
• 6.200 RESTful Services Wizard (Auto-Enable REST Access)
  • 6.200.1 Specify Details
  • 6.200.2 RESTful Summary
• 6.201 RESTful Services Wizard and Object Dialog Boxes
  • 6.201.1 Resource Module
  • 6.201.2 Resource Template
  • 6.201.3 Resource Handler
    • 6.201.3.1 Resource Handler Editing Pane
  • 6.201.4 RESTful Summary
• 6.202 RESTful Services Connection
• 6.203 RESTful Services Privilege
• 6.204 RESTful Services Roles
• 6.205 Select Current Repository
• 6.206 Cannot Capture Table
• 6.207 Report Panel
• 6.208 Reset Expired Password (Enter New Password)
• 6.209 Revision Lister
• 6.210 Run/Debug/Profile PL/SQL
• 6.211 Create/Edit Breakpoint
  • 6.211.1 Definition tab
  • 6.211.2 Conditions tab
  • 6.211.3 Actions tab
• 6.212 Save/Save As, or Select File
• 6.213 Save or Open Cart Tool Configuration
• 6.214 Save Files
• 6.215 Unable to Save Files
• 6.216 Save Style Settings
• 6.217 Schema Differences Source or Destination Error
• 6.218 Script Execution Failed
• 6.219 Script Generation Complete
• 6.220 Set Data Mapping
• 6.221 Add/Edit Rule
• 6.222 Set Encoding
• 6.223 Set Pause Continue
• 6.224 Shared Wizard Pages
  • 6.224.1 Types
  • 6.224.2 Specify Objects
  • 6.224.3 Data
  • 6.224.4 Summary
• 6.225 Sign In (checking for updates)
• 6.226 Single Record View
• 6.227 Save Snippet (User-Defined)
• 6.228 Edit Snippets (User-Defined)
• 6.229 Show SQL
• 6.230 Start Date, End Date, Repeat Interval, Comments (Scheduler)
• 6.231 Subversion: Add Property
• 6.232 Subversion: Add to Source Control
• 6.233 Subversion: Apply Patch
• 6.234 Subversion: Branch/Tag
• 6.235 Subversion: Check Out from Subversion
• 6.236 Subversion: Commit Resources
• 6.237 Subversion: Commit Working Copy
• 6.238 Subversion: Confirm Checkout
• 6.239 Subversion: Create Remote Directory
• 6.240 Subversion: Create Subversion Repository
• 6.241 Subversion: Create/Edit Subversion Connection
• 6.242 Subversion: Delete Resources
• 6.243 Subversion: Edit Configuration File
• 6.244 Subversion: Export Files
• 6.245 Subversion: Export Subversion Connections
• 6.246 Subversion: Ignore
• 6.247 Subversion: Import Subversion Connections
• 6.248 Subversion: Import to Subversion
  • 6.248.1 Destination
  • 6.248.2 Source
  • 6.248.3 Filters
  • 6.248.4 Options
  • 6.248.5 Summary
• 6.249 Subversion: Lock Resources
• 6.250 Subversion: Merge
• 6.251 Subversion: Pending Changes
• 6.252 Subversion: Properties
• 6.253 Subversion: Remove from Subversion
• 6.254 Subversion: Repository Browser
• 6.255 Subversion: Revert Local Changes
• 6.256 Subversion: Switch
• 6.257 Subversion: Unlock Resources
• 6.258 Subversion: Update Resources
• 6.259 Subversion: Update Working Copy
• 6.260 Subversion: Versioning Properties
• 6.261 Third-Party Database Objects
• 6.262 Unable to Connect
• 6.263 Unable to Open File
• 6.264 Uninstall Oracle REST Data Services
• 6.265 Unit Testing: Action Required
• 6.266 Unit Testing: Add Category
• 6.267 Unit Testing: Add Data Type
• 6.268 Unit Testing: Add Item to Library
• 6.269 Unit Testing: Add Test Implementation
• 6.270 Unit Testing: Add Test Suite
• 6.271 Unit Testing: Add Tests or Suites to a Suite
• 6.272 Unit Testing: Copy or Rename Unit Test
• 6.273 Unit Testing: Create Unit Test
  • 6.273.1 Select Operation
  • 6.273.2 Specify Test Name
  • 6.273.3 Specify Startup
  • 6.273.4 Specify Parameters
  • 6.273.5 Specify Validations
  • 6.273.6 Specify Teardown
  • 6.273.7 Summary
• 6.274 Unit Testing: Manage Users
• 6.275 Unit Testing: Rename Test Implementation
• 6.276 Unit Testing: Result of Operation
• 6.277 Unit Testing: Synchronize Unit Test
• 6.278 Unplug Pluggable Database
• 6.279 Unsupported Database Version
• 6.280 Validate Geometry
• 6.281 View Whole Value
• 6.282 Windows
• 6.283 XMLType Column Properties

7 SQL Developer: TimesTen Support

• 7.1 Create a New TimesTen Connection
  • 7.1.1 DSN
  • 7.1.2 Easy Client/Server
  • 7.1.3 Advanced
• 7.2 Set the Cache Administrator User Name and Password
• 7.3 Start and Stop the Cache Agent
• 7.4 Create a Cache Group
  • 7.4.1 Defining a cache group and cache table attributes
  • 7.4.2 Defining the root table
    • 7.4.2.1 Selecting the columns to cache
    • 7.4.2.2 Specifying the table attributes
    • 7.4.2.3 Specifying an aging policy
    • 7.4.2.4 Verifying the root table definition
  • 7.4.3 Defining the child tables
    • 7.4.3.1 Selecting the columns to cache
    • 7.4.3.2 Specifying the table attributes
    • 7.4.3.3 Completing the definitions of the child tables
    • 7.4.3.4 Verifying the cache group definition
• 7.5 Drop a Cache Group
• 7.6 Load or Refresh a Cache Group
• 7.7 Flush a Cache Group
• 7.8 Unload a Cache Group
• 7.9 Alter the Automatic Refresh Attributes of a Cache Group
• 7.10 Specify and Display LOB Data Types
• 7.11 Specify the INLINE Attribute for Columns
• 7.12 Compute Table Size
• 7.13 Use a REF CURSOR as an OUTPUT Parameter
• 7.14 Create an Index on a TimesTen Table
• 7.15 Create a Primary Key Constraint
• 7.16 Change the Attributes of Primary Key
• 7.17 Create a Foreign Key Constraint
• 7.18 Drop a Constraint
• 7.19 Add an Aging Policy to a Table
• 7.20 Drop an Aging Policy from a Table
• 7.21 Change the Aging State for the Aging Policy of a Table
• 7.22 Change the Memory Usage Thresholds and LRU Aging Cycle
• 7.23 Change the Lifetime and Cycle for the Time-Based Aging Policy of a Table
• 7.24 Grant Object Privileges to a TimesTen Database Element
• 7.25 Revoke Object Privileges from a TimesTen Database Element
• 7.26 Load Data into a Table
• 7.27 Start and Stop the TimesTen Replication Agent
• 7.28 Update the Table and Column Statistics Used By the TimesTen Query Optimizer
• 7.29 Export the Table Statistics Used By the TimesTen Query Optimizer
• 7.30 Create a TimesTen Performance Metrics Snapshot
• 7.31 Drop a TimesTen Performance Metrics Snapshot
• 7.32 Edit the TimesTen Performance Metrics Configuration
• 7.33 Create a TimesTen Performance Metrics Report
  • 7.33.1 Save a report
• 7.34 Capture Data for the TimesTen Index Advisor at the Connection Level
  • 7.34.1 Capture data from a SQL worksheet
    • 7.34.1.1 Saving index recommendations from a SQL worksheet
  • 7.34.2 Capture data from a SQL workload script
• 7.35 Capture Data for the TimesTen Index Advisor at the Database Level
• 7.36 View the TimesTen Index Advisor Capture State
• 7.37 Load Data from an Oracle Database into a TimesTen Database
• 7.38 Load Data from an Oracle Database Table into an Existing TimesTen Table

8 SQL Developer Accessibility Information

• 8.1 About Oracle SQL Developer Accessibility
• 8.2 Using a Screen Reader and Java Access Bridge with Oracle SQL Developer
• 8.3 Oracle SQL Developer Features that Support Accessibility
  • 8.3.1 Keyboard Access
  • 8.3.2 Screen Reader Readability
  • 8.3.3 Flexibility in Font and Color Choices
  • 8.3.4 No Audio-only Feedback
  • 8.3.5 No Dependency on Blinking Cursor and Animation
  • 8.3.6 Screen Magnifier Usability
  • 8.3.7 How to Change the Editor or Tabbed View of a File
  • 8.3.8 How to Read Text in a Multiline Edit Field
  • 8.3.9 How to Read the Line Number in the Source Editor
  • 8.3.10 How to Access Exception Stack HTML Links and Generated Javadoc Links in the Log Window
• 8.4 Recommendations for Customizing Oracle SQL Developer
  • 8.4.1 How to Customize the Accelerators Keys
  • 8.4.2 How to Pass a Conflicting Accelerator Key to Oracle SQL Developer
  • 8.4.3 How to Change the Look and Feel of SQL Developer
  • 8.4.4 How to Customize the Fonts in Code Editors
  • 8.4.5 How to Customize Syntax Highlighting
  • 8.4.6 How to Display Line Numbers in Code Editors
  • 8.4.7 How to Change the Timing for Completion Insight
  • 8.4.8 How to Specify the Columns in the Debugger
• 8.5 Highly Visual Features of Oracle SQL Developer

Index