Table of Contents

• List of Figures
• List of Tables
• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Product Accessibility
  • Related Documents
  • Conventions
  • Third-Party License Information
    • ActiveDBSoft
    • Antlr 2.7.6, 3.1.3
    • Apache Commons Logging 1.0.4, 1.1
    • Apache Geronimo JMS 1.1 Specification 1.0, 1.1
    • Apache POI 3.10.1
    • ASM 5.0.4
    • Bouncy Castle Crypto API 1.45
    • Commons HttpClient 4.2.6
    • dom4j 1.6.1
    • HttpComponents
    • iText OEM Desktop 5.5.3
    • Jackson 1.9.3, 2.8.5
    • JGoodies Looks 1.3.1
    • jGraphX.jar 2.1.0.9
    • JLine 2.12.1
    • JSch 0.1.51
    • JXLayer 4.0
    • JZlib 1.1.3
    • Log4j 1.2.8, 1.2.13, 1.2.15, 1.2.17, 1.3
    • MigLayout 4.0
    • POI 2.5.1
    • Regular Expression Package 1.3
    • StringTemplate 3.1
    • SVNKit 1.0.0, 1.3.0
• Changes in This Release for Oracle SQL Developer User’s Guide
  • Changes in Oracle SQL Developer Release 18.4
    • New Features
    • Desupported Features
  • Changes in Oracle SQL Developer Release 18.3
    • New Features
    • Desupported Features
  • Changes in Oracle SQL Developer Release 18.2
    • New Features
  • Changes in Oracle SQL Developer Release 18.1
    • New Features
• 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.7.6 Semantic Analysis
      • 1.7.6.1 SQL Injection Detection
  • 1.8 Using the SQL Worksheet
    • 1.8.1 SQL*Plus Statements 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 Adding Data Files to the Cart
    • 1.15.2 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 SQL Developer Support for RDF Data
  • 1.27 Using the Help
  • 1.28 SQL Developer Usage Suggestions
    • 1.28.1 SQL History Shortcuts
    • 1.28.2 Unshared Worksheets
    • 1.28.3 SQL Worksheet Bookmarks
    • 1.28.4 Oracle Data Miner
    • 1.28.5 Formatted Display of SQL Trace (.trc) Files
    • 1.28.6 Keyboard Navigation: Alt + Page Down/Up to Move Among Tabs
    • 1.28.7 Folders for Organizing Connections
    • 1.28.8 Third-Party Databases and SQL Developer
    • 1.28.9 Debugger Ports and Firewalls
    • 1.28.10 Viewing Multiple Tables
    • 1.28.11 Customizing SQL Developer Appearance
    • 1.28.12 Maximizing Tab Panes
    • 1.28.13 Default Path for Running Scripts
    • 1.28.14 Shutting Down and Restarting the Database
    • 1.28.15 Feature Requests
    • 1.28.16 Discussion Forums
    • 1.28.17 Help Text Font Size
    • 1.28.18 Procedure and Function Signatures
    • 1.28.19 Type-Ahead in Navigators
    • 1.28.20 Extended Paste
    • 1.28.21 Closing Tabbed Windows Using the Mouse Wheel
    • 1.28.22 Go to Last Edit Location
    • 1.28.23 Closing Tabbed Windows Using the Context Menu
    • 1.28.24 List of All Open Windows
    • 1.28.25 Go to Subprogram Implementation from Package Window
    • 1.28.26 Select Multiple Table or Column Names in Completion Insight
    • 1.28.27 Startup Time and Automatic Check for Updates
  • 1.29 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: 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 Configuration File Option
  • 6.10 Choose Directory
  • 6.11 Clone PDB to Oracle Cloud
  • 6.12 Clone Pluggable Database
  • 6.13 Cloud Migrations Wizard
    • 6.13.1 AWS Redshift Database
    • 6.13.2 Autonomous Data Warehouse Cloud
    • 6.13.3 Summary
  • 6.14 Color Palette and Custom Colors
  • 6.15 Configure Extension
  • 6.16 Configure File Type Associations
  • 6.17 Configure OSS
  • 6.18 Copy Columns
  • 6.19 Copy Objects
  • 6.20 Copy to Hadoop / Append to Hadoop Table
  • 6.21 Copy to Oracle
  • 6.22 Component Palette
  • 6.23 Component Palette: Configure Component Palette
  • 6.24 Component Palette: Create Palette Page
  • 6.25 Component Palette: New/Edit Code Snippet
  • 6.26 Component Palette: New Section/Rename Section
  • 6.27 Confirm Drop Application
  • 6.28 Confirm Running SQL
  • 6.29 Connection Has Uncommitted Changes
  • 6.30 Create New Object
  • 6.31 Create/Edit Chain
  • 6.32 Create/Edit Credential
  • 6.33 Create/Edit/Select Database Connection
    • 6.33.1 Oracle tab
    • 6.33.2 TimesTen tab
    • 6.33.3 Amazon Redshift tab
    • 6.33.4 DB2 tab
    • 6.33.5 Hive tab
    • 6.33.6 JDBC tab
    • 6.33.7 MySQL tab
    • 6.33.8 PostgreSQL tab
    • 6.33.9 SQL Server and Sybase tab
    • 6.33.10 Teradata tab
    • 6.33.11 Creating and Editing Connections
  • 6.34 New/Edit Cloud Connection
    • 6.34.1 Advanced Connection Information
  • 6.35 New/Edit NoSQL Connection
  • 6.36 Rename Model (Migration)
  • 6.37 Delete Confirmation
  • 6.38 Delete Confirmation (Migration)
  • 6.39 Rename Database Item (Migration)
  • 6.40 Select Connection
  • 6.41 Connection Information
  • 6.42 No Connection Found
  • 6.43 Connection Rename Error
  • 6.44 New Folder (Connections)
  • 6.45 Continue After Pause
  • 6.46 Select Library
  • 6.47 Create Library
  • 6.48 CVS: Check Out from CVS
  • 6.49 CVS: Create/Edit CVS Connection
  • 6.50 CVS: Import to CVS
  • 6.51 CVS: Log In to CVS
  • 6.52 Data Import Wizard
    • 6.52.1 Data Preview
    • 6.52.2 Import Method
    • 6.52.3 Import Metadata Source
    • 6.52.4 Choose Columns
    • 6.52.5 Column Definition
    • 6.52.6 Options
    • 6.52.7 Test
    • 6.52.8 Finish
  • 6.53 Export/Import Connections
    • 6.53.1 Export Connections
    • 6.53.2 Import Connections
  • 6.54 Create/Edit Database Destination
  • 6.55 Create/Edit Destination Group (Database or External)
  • 6.56 Create/Edit Database Link
  • 6.57 Create/Edit Index
    • 6.57.1 Definition
    • 6.57.2 Properties
    • 6.57.3 Storage
    • 6.57.4 Partitions
    • 6.57.5 DDL
  • 6.58 Create File Watcher
  • 6.59 Create Filter
  • 6.60 Create Function or Procedure
  • 6.61 Create/Edit Job
    • 6.61.1 Job Details
    • 6.61.2 Destination
    • 6.61.3 Job Arguments
    • 6.61.4 Notification
    • 6.61.5 Properties
    • 6.61.6 Summary/SQL
  • 6.62 Create/Edit Job Class
  • 6.63 Create/Edit Materialized View Log
  • 6.64 Create PL/SQL Package
  • 6.65 Create Pluggable Database
  • 6.66 Create/Edit Program
  • 6.67 Create/Edit Role
  • 6.68 Create/Edit Schedule
  • 6.69 Create/Edit Sequence
  • 6.70 Create SQL File
  • 6.71 Create/Edit Synonym
  • 6.72 Create Table (quick creation)
  • 6.73 Create/Edit Table (with advanced options)
    • 6.73.1 Columns pane
    • 6.73.2 Constraints
    • 6.73.3 Primary Key Constraint
    • 6.73.4 Unique Constraints
    • 6.73.5 Foreign Keys Constraints
    • 6.73.6 Check Constraints
    • 6.73.7 Indexes pane
    • 6.73.8 In-Memory pane
    • 6.73.9 Storage pane
    • 6.73.10 Column Sequences pane
    • 6.73.11 Table Properties pane
    • 6.73.12 LOB Parameters pane
    • 6.73.13 Partitioning pane
    • 6.73.14 Subpartition Templates pane
    • 6.73.15 Partition Definitions pane
    • 6.73.16 Partition Sets pane
    • 6.73.17 Index Organized Properties pane
    • 6.73.18 External Table Properties pane
    • 6.73.19 Comment pane
    • 6.73.20 DDL pane
    • 6.73.21 Hive Tables
      • 6.73.21.1 Hive Tables: Partitions
      • 6.73.21.2 Hive Tables: Buckets
      • 6.73.21.3 Hive Tables: Skew
      • 6.73.21.4 Hive Tables: Storage
      • 6.73.21.5 Hive Tables: Table Properties
  • 6.74 Storage Options
  • 6.75 Create/Edit Tablespace
    • 6.75.1 File Specifications tab
    • 6.75.2 Properties tab
    • 6.75.3 Default Parameters tab
    • 6.75.4 DDL tab
  • 6.76 Create Trigger
  • 6.77 Create Type (User-Defined)
  • 6.78 Create/Edit User
    • 6.78.1 User tab
    • 6.78.2 Granted Roles tab
    • 6.78.3 System Privileges tab
    • 6.78.4 Quotas tab
    • 6.78.5 SQL tab
  • 6.79 Create/Edit User Defined Report
  • 6.80 Create/Edit User Defined Report Folder
  • 6.81 Create/Edit View
    • 6.81.1 SQL Query tab or pane
    • 6.81.2 View Properties or Materialized View Properties pane
    • 6.81.3 DDL tab or pane
    • 6.81.4 Quick-Pick Objects pane
    • 6.81.5 FROM Clause pane
    • 6.81.6 SELECT Clause pane
    • 6.81.7 WHERE Clause pane
    • 6.81.8 GROUP BY Clause pane
    • 6.81.9 HAVING Clause pane
    • 6.81.10 ORDER BY Clause pane
  • 6.82 Create Window
  • 6.83 Create Window Group
  • 6.84 Create XML Document from XML Schema
  • 6.85 Create XML Schema
  • 6.86 Custom Filters
  • 6.87 Customize Toolbars
  • 6.88 Data Pump Export
    • 6.88.1 Source page
    • 6.88.2 Tablespaces page
    • 6.88.3 Schemas page
    • 6.88.4 Tables page
    • 6.88.5 Filter page
    • 6.88.6 Table Data page
    • 6.88.7 Options page
    • 6.88.8 Output Files page
    • 6.88.9 OSS Transfer page
    • 6.88.10 Job Schedule page
    • 6.88.11 Summary page
  • 6.89 Data Pump Import
    • 6.89.1 Type page
    • 6.89.2 Tablespaces page
    • 6.89.3 Schemas page
    • 6.89.4 Tables page
    • 6.89.5 Filter page
    • 6.89.6 Table Data page
    • 6.89.7 Remapping page
    • 6.89.8 Options page
    • 6.89.9 Job Schedule page
    • 6.89.10 Summary page
  • 6.90 Database Copy
    • 6.90.1 Source/Destination page
    • 6.90.2 Object Types page
    • 6.90.3 Select Schemas page
    • 6.90.4 Select Tablespace page
    • 6.90.5 Specify Objects page
    • 6.90.6 Specify Data page
    • 6.90.7 Summary page
  • 6.91 Database Differences
    • 6.91.1 Source/Destination page
    • 6.91.2 Types to Diff page
    • 6.91.3 Specify Objects page
    • 6.91.4 Summary page
  • 6.92 Database Export (Unload Database Objects and Data)
    • 6.92.1 Source/Destination page
    • 6.92.2 Types to Export page
    • 6.92.3 Specify Objects page
    • 6.92.4 Specify Data page
    • 6.92.5 Export Summary page
  • 6.93 DDL Panel for Creating or Editing an Object
  • 6.94 Debugger - Attach to JPDA
  • 6.95 Deploy or Import Application
  • 6.96 Deploy Objects to Cloud
    • 6.96.1 Cloud
    • 6.96.2 Authorization
    • 6.96.3 Deploy File
    • 6.96.4 Deploy DDL
    • 6.96.5 Deploy Data
    • 6.96.6 Deployment Console
    • 6.96.7 Unsupported Cart Object for Cloud Deployment
    • 6.96.8 Other Errors (Invalid or Missing Entries)
  • 6.97 Describe Object Window
  • 6.98 Diff Objects
  • 6.99 Drop Pluggable Database
  • 6.100 Drop REST Services for Schema
  • 6.101 Edit/View Value (Data or Table Column)
  • 6.102 Enter Bind Values
  • 6.103 Erase from Disk
  • 6.104 Error Writing to Export File
  • 6.105 Export Error
  • 6.106 Export Data
  • 6.107 Export Objects
  • 6.108 Export Resource Module, Privilege, and Role
  • 6.109 Export: Unique Names Warning
  • 6.110 External Locator Configuration
  • 6.111 External Tools
  • 6.112 Create/Edit External Tool
    • 6.112.1 Program Options
    • 6.112.2 Display
    • 6.112.3 Integration
    • 6.112.4 Availability
  • 6.113 Choose Offline Options
  • 6.114 Edit Font Location
  • 6.115 Edit Header or Footer (PDF Formatting)
  • 6.116 Edit Join
  • 6.117 Extract Variable/Function/CTE for Refactoring
  • 6.118 Feature Missing
  • 6.119 Feature Required
  • 6.120 File Processing
  • 6.121 Filter
  • 6.122 Filter Object Types
  • 6.123 Filter Schemas
  • 6.124 Filter Error
  • 6.125 Find/Highlight
  • 6.126 Git: Add
  • 6.127 Git: Add All
  • 6.128 Git: Add to .gitignore File
  • 6.129 Git: Checkout Revision
  • 6.130 Git: Clone from Git
  • 6.131 Git: Commit
  • 6.132 Git: Commit All
  • 6.133 Git: Create Branch
  • 6.134 Git: Create Tag
  • 6.135 Git: Export Committed Changes
  • 6.136 Git: Export Uncommitted Changes
  • 6.137 Git: Fetch from Git
  • 6.138 Git: Initialize Repository
  • 6.139 Git: Merge
  • 6.140 Git: Pull from Git
  • 6.141 Git: Push to Git
  • 6.142 Git: Revert
  • 6.143 Insert Macro
  • 6.144 Externally Modified Files
  • 6.145 Find/Replace Text
  • 6.146 Find Result
  • 6.147 Format Properties (Advanced Formatting)
  • 6.148 Generate Patch
  • 6.149 Go to Bookmark
  • 6.150 Go to Line Number
  • 6.151 Go to Line Number: Error
  • 6.152 History
  • 6.153 Import Using Oracle Loader for Hadoop
  • 6.154 Import Using Oracle SQL Connector for HDFS
  • 6.155 Install/Run Oracle REST Data Services
    • 6.155.1 ORDS File Locations
    • 6.155.2 Database Connection
    • 6.155.3 Database Options
    • 6.155.4 Select Tablespace
    • 6.155.5 PL/SQL Gateway
    • 6.155.6 APEX RESTful Services
    • 6.155.7 Run Standalone Mode
    • 6.155.8 ORDS Users
    • 6.155.9 Summary
  • 6.156 Install SQL Translator
    • 6.156.1 Installing a Translator and Creating a Profile: Usage Notes
  • 6.157 Invalid Database Version
  • 6.158 Load Extension
  • 6.159 Load Keyboard Scheme
  • 6.160 LOB Descriptors
  • 6.161 Maintain Spatial Metadata
  • 6.162 Manage Columns
  • 6.163 Manage Connections (REST)
  • 6.164 Manage Features and Updates
  • 6.165 Map Connection
  • 6.166 Merge Migration Projects
  • 6.167 Modify Pluggable State
  • 6.168 Modify Value
  • 6.169 Data Move Details
  • 6.170 New/Edit Change Set
  • 6.171 New Procedure (Refactoring)
  • 6.172 New/Edit Local or Remote Port Forward
  • 6.173 Edit SSH Connection
  • 6.174 No Lock
  • 6.175 No Object Found
  • 6.176 No Object Selected
  • 6.177 Object Preferences
  • 6.178 Offline Generation Error - Destination Directory
  • 6.179 Open File
  • 6.180 Oracle-Only Report
  • 6.181 Paste
  • 6.182 Perforce: Add Files to Perforce
  • 6.183 Perforce: Connection
  • 6.184 Perforce: Create Changelist
  • 6.185 Perforce: Delete Files
  • 6.186 Perforce: Login
  • 6.187 Perforce: Open Files for Edit
  • 6.188 Perforce: Revert Files
  • 6.189 Perforce: Sync Files
  • 6.190 Perforce: Submit Changelist
  • 6.191 Plug In Pluggable Database
  • 6.192 Print Preview
  • 6.193 Privilege Warning for Migration
  • 6.194 Publish to REST
  • 6.195 Recent Files
  • 6.196 Delete or Truncate Repository
    • 6.196.1 Error Truncating Repository
  • 6.197 Rename Local Variable
  • 6.198 Rename Tab
  • 6.199 Rename Procedure
  • 6.200 Repair (Validate) Oracle REST Data Services
  • 6.201 REST Data Services Connection
  • 6.202 REST Data Services Connection: Authentication Failed
  • 6.203 REST Data Services Connection: Remove Connection
  • 6.204 RESTful Services Wizard (Auto-Enable REST Access)
    • 6.204.1 Specify Details
    • 6.204.2 RESTful Summary
  • 6.205 RESTful Services Wizard and Object Dialog Boxes
    • 6.205.1 Resource Module
    • 6.205.2 Resource Template
    • 6.205.3 Resource Handler
      • 6.205.3.1 Resource Handler Editing Pane
    • 6.205.4 RESTful Summary
  • 6.206 RESTful Services Connection
  • 6.207 RESTful Services Privilege
  • 6.208 RESTful Services Roles
  • 6.209 Select Current Repository
  • 6.210 Cannot Capture Table
  • 6.211 Report Panel
  • 6.212 Reset Expired Password (Enter New Password)
  • 6.213 Revision Lister
  • 6.214 Run/Debug/Profile PL/SQL
  • 6.215 Create/Edit Breakpoint
    • 6.215.1 Definition tab
    • 6.215.2 Conditions tab
    • 6.215.3 Actions tab
  • 6.216 Save/Save As, or Select File
  • 6.217 Save or Open Cart Tool Configuration
  • 6.218 Save Files
  • 6.219 Unable to Save Files
  • 6.220 Save Style Settings
  • 6.221 Schema Differences Source or Destination Error
  • 6.222 Script Execution Failed
  • 6.223 Script Generation Complete
  • 6.224 Set Data Mapping
  • 6.225 Add/Edit Rule
  • 6.226 Set Encoding
  • 6.227 Set Pause Continue
  • 6.228 Shared Wizard Pages
    • 6.228.1 Types
    • 6.228.2 Specify Objects
    • 6.228.3 Data
    • 6.228.4 Summary
  • 6.229 Sign In (checking for updates)
  • 6.230 Single Record View
  • 6.231 Save Snippet (User-Defined)
  • 6.232 Edit Snippets (User-Defined)
  • 6.233 Show SQL
  • 6.234 Start Date, End Date, Repeat Interval, Comments (Scheduler)
  • 6.235 Subversion: Add Property
  • 6.236 Subversion: Add to Source Control
  • 6.237 Subversion: Apply Patch
  • 6.238 Subversion: Branch/Tag
  • 6.239 Subversion: Check Out from Subversion
  • 6.240 Subversion: Commit Resources
  • 6.241 Subversion: Commit Working Copy
  • 6.242 Subversion: Confirm Checkout
  • 6.243 Subversion: Create Remote Directory
  • 6.244 Subversion: Create Subversion Repository
  • 6.245 Subversion: Create/Edit Subversion Connection
  • 6.246 Subversion: Delete Resources
  • 6.247 Subversion: Edit Configuration File
  • 6.248 Subversion: Export Files
  • 6.249 Subversion: Export Subversion Connections
  • 6.250 Subversion: Ignore
  • 6.251 Subversion: Import Subversion Connections
  • 6.252 Subversion: Import to Subversion
    • 6.252.1 Destination
    • 6.252.2 Source
    • 6.252.3 Filters
    • 6.252.4 Options
    • 6.252.5 Summary
  • 6.253 Subversion: Lock Resources
  • 6.254 Subversion: Merge
  • 6.255 Subversion: Pending Changes
  • 6.256 Subversion: Properties
  • 6.257 Subversion: Remove from Subversion
  • 6.258 Subversion: Repository Browser
  • 6.259 Subversion: Revert Local Changes
  • 6.260 Subversion: Switch
  • 6.261 Subversion: Unlock Resources
  • 6.262 Subversion: Update Resources
  • 6.263 Subversion: Update Working Copy
  • 6.264 Subversion: Versioning Properties
  • 6.265 Third-Party Database Objects
  • 6.266 Unable to Connect
  • 6.267 Unable to Open File
  • 6.268 Uninstall Oracle REST Data Services
  • 6.269 Unit Testing: Action Required
  • 6.270 Unit Testing: Add Category
  • 6.271 Unit Testing: Add Data Type
  • 6.272 Unit Testing: Add Item to Library
  • 6.273 Unit Testing: Add Test Implementation
  • 6.274 Unit Testing: Add Test Suite
  • 6.275 Unit Testing: Add Tests or Suites to a Suite
  • 6.276 Unit Testing: Copy or Rename Unit Test
  • 6.277 Unit Testing: Create Unit Test
    • 6.277.1 Select Operation
    • 6.277.2 Specify Test Name
    • 6.277.3 Specify Startup
    • 6.277.4 Specify Parameters
    • 6.277.5 Specify Validations
    • 6.277.6 Specify Teardown
    • 6.277.7 Summary
  • 6.278 Unit Testing: Manage Users
  • 6.279 Unit Testing: Rename Test Implementation
  • 6.280 Unit Testing: Result of Operation
  • 6.281 Unit Testing: Synchronize Unit Test
  • 6.282 Unplug Pluggable Database
  • 6.283 Unsupported Database Version
  • 6.284 Validate Geometry
  • 6.285 View Whole Value
  • 6.286 Windows
  • 6.287 XMLType Column Properties
• Index