Table of Contents

• List of Figures
• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Product Accessibility
  • Related Documents
  • Conventions
  • Third-Party License Information
    • ActiveQueryBuilder 1.9.0.1154
    • Antlr 3.1.3
    • Apache Commons Logging 1.2
    • Apache Mina SSHD 2.4.0
    • Apache POI 4.1.2
    • Google Guava 30.0
    • HttpComponents Http Client 4.5.12
    • HttpCore 4.4.13
    • iText OEM Desktop 5.5.13.1
    • jackson-annotations 2.10.3
    • jackson-core 2.10.3
    • jackson-jr-objects 2.10.3
    • JGoodies Looks 1.3.1
    • jGraphx 4.1.1
    • jLine 2.14.6
    • JXLayer 4.0
    • Kafka 2.4
    • Launch4j 3.12
    • Liquibase 3.8.9
    • Log4j 2.13.1
    • StringTemplate 3.1, 4.3
    • SVNKit 1.0.0
• 1 Changes in Release 20.4 for Oracle SQL Developer User's Guide
• 2 SQL Developer Concepts and Usage
  • 2.1 About SQL Developer
  • 2.2 Installing and Getting Started with SQL Developer
  • 2.3 SQL Developer User Interface
    • 2.3.1 Menus for SQL Developer
    • 2.3.2 Restoring the Original "Look and Feel"
  • 2.4 Database Objects
    • 2.4.1 Applications (Application Express 3.0.1 and Later)
    • 2.4.2 Cache Groups (Oracle TimesTen In-Memory Database)
    • 2.4.3 Chains
    • 2.4.4 Credentials
    • 2.4.5 Database Destinations
    • 2.4.6 Database Links (Public and Private)
    • 2.4.7 Destination Groups
    • 2.4.8 Directories
    • 2.4.9 Editions
    • 2.4.10 File Watchers
    • 2.4.11 Functions
    • 2.4.12 Indexes
    • 2.4.13 Java Sources
    • 2.4.14 Jobs
    • 2.4.15 Job Classes
    • 2.4.16 Operators
    • 2.4.17 Materialized Views
    • 2.4.18 Materialized View Logs
    • 2.4.19 Multitenant Container Database (CDB)
    • 2.4.20 Packages
    • 2.4.21 Procedures
    • 2.4.22 Programs
    • 2.4.23 Queues
    • 2.4.24 Queue Tables
    • 2.4.25 Recycle Bin
    • 2.4.26 Replication Schemes (Oracle TimesTen In-Memory Database)
    • 2.4.27 Schedules
    • 2.4.28 Sequences
    • 2.4.29 Synonyms (Public and Private)
    • 2.4.30 Tables
      • 2.4.30.1 Flashback Table Support
    • 2.4.31 Triggers
    • 2.4.32 Types
    • 2.4.33 Users (Other Users)
    • 2.4.34 Views
    • 2.4.35 Window Groups
    • 2.4.36 Windows
    • 2.4.37 XML DB Repository
    • 2.4.38 XML Schemas
    • 2.4.39 Captured and Converted Database Objects (for Migration)
  • 2.5 Database Connections
    • 2.5.1 Using Folders to Group Connections
    • 2.5.2 Sharing of Connections
    • 2.5.3 Advanced Security for JDBC Connection to the Database
    • 2.5.4 Connections with Operating System (OS) Authentication
    • 2.5.5 Connections with Proxy Authentication
    • 2.5.6 Connections with SSH Authentication
  • 2.6 Entering and Modifying Data
  • 2.7 Running and Debugging Functions and Procedures
    • 2.7.1 Using Bookmarks When Editing Functions and Procedures
    • 2.7.2 Remote Debugging
    • 2.7.3 Displaying SQL Trace (.trc) Files
    • 2.7.4 Using the PL/SQL Hierarchical Profiler
    • 2.7.5 Setting Expression Watches
    • 2.7.6 Semantic Analysis
      • 2.7.6.1 SQL Injection Detection
  • 2.8 Using the SQL Worksheet
    • 2.8.1 SQL*Plus and SQLcl Commands Supported in SQL Worksheet
    • 2.8.2 Script Runner
    • 2.8.3 Execution Plan
    • 2.8.4 Autotrace Pane
    • 2.8.5 DBMS Output Pane
    • 2.8.6 OWA Output Pane
    • 2.8.7 SQL History
    • 2.8.8 Query Builder
    • 2.8.9 Command-Line Interface for SQL Formatting
    • 2.8.10 SQL Worksheet "Hints" for Formatting Output
    • 2.8.11 Gauges: In the SQL Worksheet and User-Defined Reports
    • 2.8.12 Entering OLAP DML Statements in the SQL Worksheet
  • 2.9 Using Snippets to Insert Code Fragments
    • 2.9.1 User-Defined Snippets
  • 2.10 Finding Database Objects
  • 2.11 Using Recent Objects
  • 2.12 Using Versioning
    • 2.12.1 About Subversion and SQL Developer
    • 2.12.2 Pending Changes
  • 2.13 Using DBA Features in SQL Developer
    • 2.13.1 Container Database (CDB)
    • 2.13.2 Database Configuration
      • 2.13.2.1 Initialization Parameters
      • 2.13.2.2 Automatic Undo Management
      • 2.13.2.3 Current Database Properties
      • 2.13.2.4 Restore Points
      • 2.13.2.5 View Database Feature Usage
    • 2.13.3 Database Status
      • 2.13.3.1 Status
      • 2.13.3.2 DB Instance
      • 2.13.3.3 Instance Viewer
    • 2.13.4 Data Guard
    • 2.13.5 Data Pump
      • 2.13.5.1 Export Jobs
      • 2.13.5.2 Import Jobs
    • 2.13.6 Oracle Sharding
    • 2.13.7 Performance
      • 2.13.7.1 Snapshots
      • 2.13.7.2 Baselines
      • 2.13.7.3 Baseline Templates
      • 2.13.7.4 Automatic Database Diagnostic Monitor (ADDM)
      • 2.13.7.5 ASH (Active Session History) Report Viewer
      • 2.13.7.6 AWR (Automatic Workload Repository)
    • 2.13.8 RMAN Backup/Recovery
      • 2.13.8.1 Backup Jobs
      • 2.13.8.2 Backup Sets
      • 2.13.8.3 Image Copies
      • 2.13.8.4 RMAN Settings
      • 2.13.8.5 Scheduled RMAN Actions
      • 2.13.8.6 Using Action Jobs
    • 2.13.9 Resource Manager
      • 2.13.9.1 Consumer Group Mappings
      • 2.13.9.2 Consumer Groups
      • 2.13.9.3 Plans
      • 2.13.9.4 Settings
      • 2.13.9.5 Statistics
    • 2.13.10 SQL Translator FrameWork
      • 2.13.10.1 SQL Translator Profiles
      • 2.13.10.2 SQL Translators
    • 2.13.11 Scheduler
      • 2.13.11.1 Global Attributes
      • 2.13.11.2 Job Classes
      • 2.13.11.3 External Destinations
    • 2.13.12 Security
      • 2.13.12.1 Audit Settings
      • 2.13.12.2 Profiles
      • 2.13.12.3 Roles
      • 2.13.12.4 Users
    • 2.13.13 Storage
      • 2.13.13.1 Archive Logs
      • 2.13.13.2 Control Files
      • 2.13.13.3 Datafiles
      • 2.13.13.4 Redo Log Groups
      • 2.13.13.5 Rollback Segments
      • 2.13.13.6 Tablespaces
      • 2.13.13.7 Temporary Tablespace Groups
    • 2.13.14 Tuning
      • 2.13.14.1 Real Time SQL Monitor
  • 2.14 Scheduling Jobs Using SQL Developer
    • 2.14.1 Scheduler Design Editor
  • 2.15 Using the Cart
    • 2.15.1 Adding Data Files to the Cart
    • 2.15.2 Cart Versus Database Export Wizard
  • 2.16 Spatial Support in SQL Developer
    • 2.16.1 Context Menu Operations on Spatial Data and Metadata
    • 2.16.2 Map Visualization of Spatial Data
      • 2.16.2.1 Visualizing Geometries by Creating and Executing a Query
      • 2.16.2.2 Visualizing Geometries from the Table Data Grid
  • 2.17 Change Manager Support in SQL Developer
    • 2.17.1 Change Plan Administrators and Developers
    • 2.17.2 Developing Change Plans with SQL Developer
      • 2.17.2.1 Creating a Repository Connection
      • 2.17.2.2 Creating and Deleting Change Plans
      • 2.17.2.3 Adding and Updating Change Items
      • 2.17.2.4 Using Change Plans to Capture Change in SQL Developer
    • 2.17.3 Change Manager Actions to Perform with Enterprise Manager
      • 2.17.3.1 Creating Change Plans from Change Manager Schema Comparisons
      • 2.17.3.2 Deploying Change Plans
  • 2.18 Apache Hadoop Support in SQL Developer using Oracle Big Data Connectors and Copy to Hadoop
    • 2.18.1 Copy to Hadoop: Overview and Requirements
    • 2.18.2 Oracle Loader for Hadoop: Overview and Requirements
    • 2.18.3 Oracle SQL Connector for HDFS: Overview and Requirements
  • 2.19 Support for Oracle SQL Access to Kafka
    • 2.19.1 Overview
    • 2.19.2 Prerequisites
    • 2.19.3 Installation and Configuration
    • 2.19.4 Get Started
      • 2.19.4.1 Register a Kafka Cluster
      • 2.19.4.2 Supported Kafka Record Types
      • 2.19.4.3 Create Views to Access CSV Data in a Kafka Topic
      • 2.19.4.4 Create Views to Access JSON Data in a Kafka Topic
      • 2.19.4.5 Query Kafka Data as Continuous Streams
      • 2.19.4.6 Explore Kafka Data from a Specific Offset
      • 2.19.4.7 Explore Kafka Data from a Specific Timestamp
      • 2.19.4.8 Customize Oracle SQL Access to Kafka Views
      • 2.19.4.9 Reconfigure Existing Kafka Views When New Partitions are Added to an Existing Topic
      • 2.19.4.10 Load Kafka Data into Tables Stored in Oracle Database
      • 2.19.4.11 Load Kafka Data into Temporary Tables
    • 2.19.5 Reference Information
  • 2.20 SQL Developer Reports
    • 2.20.1 Bind Variables for Reports
    • 2.20.2 About Your Database reports
    • 2.20.3 All Objects reports
    • 2.20.4 Application Express reports
    • 2.20.5 ASH and AWR reports
    • 2.20.6 Charts reports
    • 2.20.7 Database Administration reports
    • 2.20.8 Data Dictionary reports
    • 2.20.9 Scheduler reports
    • 2.20.10 PL/SQL reports
    • 2.20.11 Security reports
    • 2.20.12 Streams reports
    • 2.20.13 Table reports
      • 2.20.13.1 Quality Assurance reports
    • 2.20.14 XML reports
    • 2.20.15 Data Modeler reports
    • 2.20.16 User Defined reports
      • 2.20.16.1 User-Defined Report Example: Chart
      • 2.20.16.2 User-Defined Report Example: Dynamic HTML
  • 2.21 SQL Developer Preferences
    • 2.21.1 Environment
    • 2.21.2 Change Management Parameters
    • 2.21.3 Code Editor
    • 2.21.4 Compare and Merge
    • 2.21.5 Database
    • 2.21.6 Debugger
    • 2.21.7 External Editor
    • 2.21.8 File Types
    • 2.21.9 Migration
    • 2.21.10 Mouse Actions
    • 2.21.11 Oracle Swift Object Storage
    • 2.21.12 Shortcut Keys (Accelerator Keys)
    • 2.21.13 SSH (Secure Shell)
    • 2.21.14 Unit Test Parameters
    • 2.21.15 Usage Reporting
    • 2.21.16 Versioning
      • 2.21.16.1 Versioning: Git
      • 2.21.16.2 Versioning: Subversion
      • 2.21.16.3 Versioning: CVS
      • 2.21.16.4 Versioning: Perforce
    • 2.21.17 Web Browser and Proxy
    • 2.21.18 XML Schemas
  • 2.22 Location of User-Related Information
  • 2.23 Java Development Kit (JDK) Location
  • 2.24 Command-Line Interface for SQL Developer
  • 2.25 Data Modeler in SQL Developer
  • 2.26 Oracle TimesTen In-Memory Database Support
  • 2.27 SQL Developer Support for RDF Data
  • 2.28 Using the Help
  • 2.29 SQL Developer Usage Suggestions
    • 2.29.1 SQL History Shortcuts
    • 2.29.2 Unshared Worksheets
    • 2.29.3 SQL Worksheet Bookmarks
    • 2.29.4 Oracle Data Miner
    • 2.29.5 Formatted Display of SQL Trace (.trc) Files
    • 2.29.6 Keyboard Navigation: Alt + Page Down/Up to Move Among Tabs
    • 2.29.7 Folders for Organizing Connections
    • 2.29.8 Third-Party Databases and SQL Developer
    • 2.29.9 Debugger Ports and Firewalls
    • 2.29.10 Viewing Multiple Tables
    • 2.29.11 Customizing SQL Developer Appearance
    • 2.29.12 Maximizing Tab Panes
    • 2.29.13 Default Path for Running Scripts
    • 2.29.14 Shutting Down and Restarting the Database
    • 2.29.15 Feature Requests
    • 2.29.16 Discussion Forums
    • 2.29.17 Help Text Font Size
    • 2.29.18 Procedure and Function Signatures
    • 2.29.19 Type-Ahead in Navigators
    • 2.29.20 Extended Paste
    • 2.29.21 Closing Tabbed Windows Using the Mouse Wheel
    • 2.29.22 Go to Last Edit Location
    • 2.29.23 Closing Tabbed Windows Using the Context Menu
    • 2.29.24 List of All Open Windows
    • 2.29.25 Go to Subprogram Implementation from Package Window
    • 2.29.26 Select Multiple Table or Column Names in Completion Insight
    • 2.29.27 Startup Time and Automatic Check for Updates
  • 2.30 For More Information About SQL Developer
• 3 SQL Developer: Migrating Third-Party Databases
  • 3.1 Migration: Basic Options and Steps
    • 3.1.1 Migrating Using the Migration Wizard
      • 3.1.1.1 Repository
      • 3.1.1.2 Project
      • 3.1.1.3 Source Database
      • 3.1.1.4 Capture
      • 3.1.1.5 Convert
      • 3.1.1.6 Translate
      • 3.1.1.7 Target Database
      • 3.1.1.8 Move Data
      • 3.1.1.9 Summary
    • 3.1.2 Copying Selected Tables to Oracle
  • 3.2 Migration: Background Information and Guidelines
    • 3.2.1 Overview of Migration
      • 3.2.1.1 Migration Implemented as SQL Developer Extensions
    • 3.2.2 Preparing a Migration Plan
      • 3.2.2.1 Task 1: Determining the Requirements of the Migration Project
      • 3.2.2.2 Task 2: Estimating Workload
      • 3.2.2.3 Task 3: Analyzing Operational Requirements
      • 3.2.2.4 Task 4: Analyzing the Application
      • 3.2.2.5 Task 5: Planning the Migration Project
    • 3.2.3 Before You Start Migrating: General Information
      • 3.2.3.1 Creating a Database User for the Migration Repository
      • 3.2.3.2 Requirements for Creating the Destination Oracle Objects
    • 3.2.4 Before You Start Migrating: Source-Specific Information
      • 3.2.4.1 Before Migrating From IBM DB2
      • 3.2.4.2 Before Migrating From Microsoft SQL Server or Sybase Adaptive Server
      • 3.2.4.3 Before Migrating From MySQL
      • 3.2.4.4 Before Migrating From Teradata
    • 3.2.5 Capturing the Source Database
      • 3.2.5.1 Offline Capture
        • 3.2.5.1.1 IBM DB2 Offline Capture Notes
    • 3.2.6 Creating and Customizing the Converted Model
      • 3.2.6.1 Correcting Errors in the Converted Model
    • 3.2.7 Generating the DDL for the Oracle Schema Objects
    • 3.2.8 Migrating the Data
      • 3.2.8.1 Transferring the Data Offline
        • 3.2.8.1.1 Creating Data Files From Microsoft SQL Server or Sybase Adaptive Server
        • 3.2.8.1.2 Creating Data Files From MySQL
        • 3.2.8.1.3 Populating the Destination Database Using the Data Files
    • 3.2.9 Making Queries Case Insensitive
    • 3.2.10 Testing the Oracle Database
      • 3.2.10.1 Testing Methodology
      • 3.2.10.2 Testing the Oracle Database
        • 3.2.10.2.1 Guidelines for Creating Tests
        • 3.2.10.2.2 Example of a Unit Test Case
    • 3.2.11 Deploying the Oracle Database
      • 3.2.11.1 Choosing a Rollout Strategy
        • 3.2.11.1.1 Phased Approach
        • 3.2.11.1.2 Big Bang Approach
        • 3.2.11.1.3 Parallel Approach
      • 3.2.11.2 Deploying the Destination Database
  • 3.3 SQL Developer User Interface for Migration
    • 3.3.1 Migration Submenu
    • 3.3.2 Other Menus: Migration Items
    • 3.3.3 Migration Preferences
    • 3.3.4 Migration Log Panes
    • 3.3.5 Using the Translation Scratch Editor
  • 3.4 Command-Line Interface for Migration
• 4 SQL Developer: Oracle REST Data Services Support
  • 4.1 Installing Oracle REST Data Services
  • 4.2 Oracle REST Data Services Administration
    • 4.2.1 About Oracle REST Data Services
    • 4.2.2 Oracle REST Data Services Administration Toolbar and Context Menu
    • 4.2.3 Connecting to Oracle REST Data Services
    • 4.2.4 REST Data Services Navigator: Global Settings and Database Settings
      • 4.2.4.1 Connections
      • 4.2.4.2 Features
      • 4.2.4.3 ORDS Public User (Database Settings Only)
      • 4.2.4.4 PL/SQL Gateway User (Database Settings Only)
      • 4.2.4.5 APEX REST Users (Database Settings Only)
      • 4.2.4.6 Security
      • 4.2.4.7 Cache Files
      • 4.2.4.8 Environment
      • 4.2.4.9 Excel
    • 4.2.5 REST Data Services Navigator: Reports
  • 4.3 Automatically Enabling REST Access to a Schema, Table, or View (AutoREST)
  • 4.4 REST Development
    • 4.4.1 About RESTful Web Services
    • 4.4.2 RESTful Services Terminology
    • 4.4.3 RESTful Services Requirements and Setup
    • 4.4.4 REST Data Services in the Connections Navigator
    • 4.4.5 REST Development Pane
• 5 SQL Developer: Unit Testing
  • 5.1 Overview of Unit Testing
  • 5.2 SQL Developer User Interface for Unit Testing
    • 5.2.1 Unit Test Submenu
    • 5.2.2 Other Menus: Unit Test Items
    • 5.2.3 Unit Test Preferences
  • 5.3 Unit Test Repository
    • 5.3.1 Managing Repository Users and Administrators
  • 5.4 Editing and Running a Unit Test
  • 5.5 Using a Dynamic Value Query to Create a Unit Test
  • 5.6 Using Lookups to Simplify Unit Test Creation
    • 5.6.1 Providing Values for Input Fields
    • 5.6.2 Automatically Creating Implementations
  • 5.7 Using Variable Substitution in Validation Actions
  • 5.8 Unit Test Library
  • 5.9 Unit Test Reports
  • 5.10 Exporting and Importing Unit Test Objects
  • 5.11 Command-Line Interface for Unit Testing
  • 5.12 Unit Testing Best Practices
    • 5.12.1 Strategy
    • 5.12.2 Test Suites
    • 5.12.3 Test Naming
    • 5.12.4 Avoiding Test Naming Clashes
    • 5.12.5 Test Implementations
    • 5.12.6 Library
    • 5.12.7 Lookups
    • 5.12.8 Test and Suite Execution
    • 5.12.9 Reports
  • 5.13 Example of Unit Testing (Tutorial)
    • 5.13.1 Create the EMPLOYEES Table
    • 5.13.2 Create the AWARD_BONUS Procedure
    • 5.13.3 Create the Unit Testing Repository
    • 5.13.4 Create a Unit Test
    • 5.13.5 Run the Unit Test
    • 5.13.6 Create and Run an Exception Unit Test
    • 5.13.7 Create a Unit Test Suite
    • 5.13.8 Run the Unit Test Suite
• 6 SQL Developer Tutorial: Creating Objects for a Small Database
  • 6.1 Create a Table (BOOKS)
  • 6.2 Create a Table (PATRONS)
  • 6.3 Create a Table (TRANSACTIONS)
  • 6.4 Create a Sequence
  • 6.5 Insert Data into the Tables
  • 6.6 Create a View
  • 6.7 Create a PL/SQL Procedure
  • 6.8 Debug a PL/SQL Procedure
  • 6.9 Use the SQL Worksheet for Queries
  • 6.10 Script for Creating and Using the Library Tutorial Objects
• 7 SQL Developer Dialog Boxes and Wizards
  • 7.1 Add Extension
  • 7.2 Add Schema Error
  • 7.3 Application Migration
  • 7.4 Associate Repository
  • 7.5 Cart Error (Objects Not Available)
  • 7.6 Change Type
  • 7.7 Check for Updates
  • 7.8 Choose Configuration File Option
  • 7.9 Choose Directory
  • 7.10 Clone PDB to Oracle Cloud
  • 7.11 Clone Pluggable Database
  • 7.12 Cloud Migrations Wizard
    • 7.12.1 AWS Redshift Database
    • 7.12.2 Autonomous Data Warehouse Cloud
    • 7.12.3 Summary
  • 7.13 Color Palette and Custom Colors
  • 7.14 Configure Extension
  • 7.15 Configure File Type Associations
  • 7.16 Configure OSS for Oracle Call Infrastructure Classic
  • 7.17 Copy Columns
  • 7.18 Copy Objects
  • 7.19 Copy to Hadoop / Append to Hadoop Table
  • 7.20 Copy to Oracle
  • 7.21 Component Palette
  • 7.22 Component Palette: Configure Component Palette
  • 7.23 Component Palette: Create Palette Page
  • 7.24 Component Palette: New/Edit Code Snippet
  • 7.25 Component Palette: New Section/Rename Section
  • 7.26 Confirm Drop Application
  • 7.27 Confirm Running SQL
  • 7.28 Connection Has Uncommitted Changes
  • 7.29 Create New Object
  • 7.30 Create/Edit Chain
  • 7.31 Create/Edit Credential
  • 7.32 Create/Edit/Select Database Connection
    • 7.32.1 Oracle
    • 7.32.2 TimesTen
    • 7.32.3 Amazon Redshift
    • 7.32.4 DB2
    • 7.32.5 Hive
    • 7.32.6 JDBC
    • 7.32.7 MySQL
    • 7.32.8 PostgreSQL
    • 7.32.9 SQL Server and Sybase
    • 7.32.10 Teradata
    • 7.32.11 Creating and Editing Connections
  • 7.33 New/Edit Cloud Connection
    • 7.33.1 Advanced Connection Information
  • 7.34 New/Edit NoSQL Connection
  • 7.35 Rename Model (Migration)
  • 7.36 Delete Confirmation
  • 7.37 Delete Confirmation (Migration)
  • 7.38 Rename Database Item (Migration)
  • 7.39 Select Connection
  • 7.40 Connection Information
  • 7.41 No Connection Found
  • 7.42 Connection Rename Error
  • 7.43 New Folder (Connections)
  • 7.44 Continue After Pause
  • 7.45 Select Library
  • 7.46 Create Library
  • 7.47 CVS: Check Out from CVS
  • 7.48 CVS: Create/Edit CVS Connection
  • 7.49 CVS: Import to CVS
  • 7.50 CVS: Log In to CVS
  • 7.51 Data Import Wizard
    • 7.51.1 Data Preview
    • 7.51.2 Import Method
    • 7.51.3 Import Metadata Source
    • 7.51.4 Choose Columns
    • 7.51.5 Column Definition
    • 7.51.6 Options
    • 7.51.7 Test
    • 7.51.8 Finish
  • 7.52 Export/Import Connections
    • 7.52.1 Export Connections
    • 7.52.2 Import Connections
  • 7.53 Create/Edit Database Destination
  • 7.54 Create/Edit Destination Group (Database or External)
  • 7.55 Create/Edit Database Link
  • 7.56 Create/Edit Index
    • 7.56.1 Definition
    • 7.56.2 Properties
    • 7.56.3 Storage
    • 7.56.4 Partitions
    • 7.56.5 DDL
  • 7.57 Create File Watcher
  • 7.58 Create Filter
  • 7.59 Create Function or Procedure
  • 7.60 Create/Edit Job
    • 7.60.1 Job Details
    • 7.60.2 Destination
    • 7.60.3 Job Arguments
    • 7.60.4 Notification
    • 7.60.5 Properties
    • 7.60.6 Summary/SQL
  • 7.61 Create/Edit Job Class
  • 7.62 Create/Edit Materialized View Log
  • 7.63 Create PL/SQL Package
  • 7.64 Create Pluggable Database
  • 7.65 Create/Edit Program
  • 7.66 Create/Edit Role
  • 7.67 Create/Edit Schedule
  • 7.68 Create/Edit Sequence
  • 7.69 Create SQL File
  • 7.70 Create/Edit Synonym
  • 7.71 Create Table (quick creation)
  • 7.72 Create/Edit Table (with advanced options)
    • 7.72.1 Columns pane
    • 7.72.2 Constraints
    • 7.72.3 Primary Key Constraint
    • 7.72.4 Unique Constraints
    • 7.72.5 Foreign Keys Constraints
    • 7.72.6 Check Constraints
    • 7.72.7 Indexes pane
    • 7.72.8 In-Memory pane
    • 7.72.9 Storage pane
    • 7.72.10 Column Sequences pane
    • 7.72.11 Table Properties pane
    • 7.72.12 LOB Parameters pane
    • 7.72.13 Partitioning pane
    • 7.72.14 Subpartition Templates pane
    • 7.72.15 Partition Definitions pane
    • 7.72.16 Partition Sets pane
    • 7.72.17 Index Organized Properties pane
    • 7.72.18 External Table Properties pane
    • 7.72.19 Comment pane
    • 7.72.20 DDL pane
    • 7.72.21 Hive Tables
      • 7.72.21.1 Hive Tables: Partitions
      • 7.72.21.2 Hive Tables: Buckets
      • 7.72.21.3 Hive Tables: Skew
      • 7.72.21.4 Hive Tables: Storage
      • 7.72.21.5 Hive Tables: Table Properties
  • 7.73 Storage Options
  • 7.74 Create/Edit Tablespace
    • 7.74.1 File Specifications tab
    • 7.74.2 Properties tab
    • 7.74.3 Default Parameters tab
    • 7.74.4 DDL tab
  • 7.75 Create Trigger
  • 7.76 Create Type (User-Defined)
  • 7.77 Create/Edit User
    • 7.77.1 User tab
    • 7.77.2 Granted Roles tab
    • 7.77.3 System Privileges tab
    • 7.77.4 Quotas tab
    • 7.77.5 SQL tab
  • 7.78 Create/Edit User Defined Report
  • 7.79 Create/Edit User Defined Report Folder
  • 7.80 Create/Edit View
    • 7.80.1 SQL Query tab or pane
    • 7.80.2 View Properties or Materialized View Properties pane
    • 7.80.3 DDL tab or pane
    • 7.80.4 Quick-Pick Objects pane
    • 7.80.5 FROM Clause pane
    • 7.80.6 SELECT Clause pane
    • 7.80.7 WHERE Clause pane
    • 7.80.8 GROUP BY Clause pane
    • 7.80.9 HAVING Clause pane
    • 7.80.10 ORDER BY Clause pane
  • 7.81 Create Window
  • 7.82 Create Window Group
  • 7.83 Create XML Document from XML Schema
  • 7.84 Create XML Schema
  • 7.85 Custom Filters
  • 7.86 Customize Toolbars
  • 7.87 Data Pump Export
    • 7.87.1 Source page
    • 7.87.2 Tablespaces page
    • 7.87.3 Schemas page
    • 7.87.4 Tables page
    • 7.87.5 Filter page
    • 7.87.6 Table Data page
    • 7.87.7 Options page
    • 7.87.8 Output Files page
    • 7.87.9 OSS Transfer page
    • 7.87.10 Job Schedule page
    • 7.87.11 Summary page
  • 7.88 Data Pump Import
    • 7.88.1 Type page
    • 7.88.2 Tablespaces page
    • 7.88.3 Schemas page
    • 7.88.4 Tables page
    • 7.88.5 Filter page
    • 7.88.6 Table Data page
    • 7.88.7 Remapping page
    • 7.88.8 Options page
    • 7.88.9 Job Schedule page
    • 7.88.10 Summary page
  • 7.89 Database Copy
    • 7.89.1 Source/Destination page
    • 7.89.2 Object Types page
    • 7.89.3 Select Schemas page
    • 7.89.4 Select Tablespace page
    • 7.89.5 Specify Objects page
    • 7.89.6 Specify Data page
    • 7.89.7 Summary page
  • 7.90 Database Differences
    • 7.90.1 Source/Destination page
    • 7.90.2 Types to Diff page
    • 7.90.3 Specify Objects page
    • 7.90.4 Summary page
  • 7.91 Database Export (Unload Database Objects and Data)
    • 7.91.1 Source/Destination page
    • 7.91.2 Types to Export page
    • 7.91.3 Specify Objects page
    • 7.91.4 Specify Data page
    • 7.91.5 Export Summary page
  • 7.92 DDL Panel for Creating or Editing an Object
  • 7.93 Debugger - Attach to JPDA
  • 7.94 Deploy or Import Application
  • 7.95 Deploy Objects to Cloud
    • 7.95.1 Deploy Objects to Cloud using Oracle Swift Object Storage
    • 7.95.2 Cloud
    • 7.95.3 Authorization
    • 7.95.4 Deploy File
    • 7.95.5 Deploy DDL
    • 7.95.6 Deploy Data
    • 7.95.7 Deployment Console
    • 7.95.8 Unsupported Cart Object for Cloud Deployment
    • 7.95.9 Other Errors (Invalid or Missing Entries)
  • 7.96 Describe Object Window
  • 7.97 Diff Objects
  • 7.98 Drop Pluggable Database
  • 7.99 Drop REST Services for Schema
  • 7.100 Edit/View Value (Data or Table Column)
  • 7.101 Enter Bind Values
  • 7.102 Erase from Disk
  • 7.103 Error Writing to Export File
  • 7.104 Export Error
  • 7.105 Export Data
  • 7.106 Export Objects
  • 7.107 Export Resource Module, Privilege, and Role
  • 7.108 Export: Unique Names Warning
  • 7.109 External Locator Configuration
  • 7.110 External Tools
  • 7.111 Create/Edit External Tool
    • 7.111.1 Program Options
    • 7.111.2 Display
    • 7.111.3 Integration
    • 7.111.4 Availability
  • 7.112 Choose Offline Options
  • 7.113 Edit Font Location
  • 7.114 Edit Header or Footer (PDF Formatting)
  • 7.115 Edit Join
  • 7.116 Extract Variable/Function/CTE for Refactoring
  • 7.117 Feature Missing
  • 7.118 Feature Required
  • 7.119 File Processing
  • 7.120 Filter
  • 7.121 Filter Object Types
  • 7.122 Filter Schemas
  • 7.123 Filter Error
  • 7.124 Find/Highlight
  • 7.125 Git: Add
  • 7.126 Git: Add All
  • 7.127 Git: Add to .gitignore File
  • 7.128 Git: Checkout Revision
  • 7.129 Git: Clone from Git
  • 7.130 Git: Commit
  • 7.131 Git: Commit All
  • 7.132 Git: Create Branch
  • 7.133 Git: Create Tag
  • 7.134 Git: Export Committed Changes
  • 7.135 Git: Export Uncommitted Changes
  • 7.136 Git: Fetch from Git
  • 7.137 Git: Initialize Repository
  • 7.138 Git: Merge
  • 7.139 Git: Pull from Git
  • 7.140 Git: Push to Git
  • 7.141 Git: Revert
  • 7.142 Insert Macro
  • 7.143 Externally Modified Files
  • 7.144 Find/Replace Text
  • 7.145 Find Result
  • 7.146 Format Properties (Advanced Formatting)
  • 7.147 Generate Patch
  • 7.148 Go to Bookmark
  • 7.149 Go to Line Number
  • 7.150 Go to Line Number: Error
  • 7.151 History
  • 7.152 Import Using Oracle Loader for Hadoop
  • 7.153 Import Using Oracle SQL Connector for HDFS
  • 7.154 Install/Run Oracle REST Data Services
    • 7.154.1 ORDS File Locations
    • 7.154.2 Database Connection
      • 7.154.2.1 Verify Oracle REST Data Services
    • 7.154.3 Database Options
    • 7.154.4 Select Tablespace
    • 7.154.5 PL/SQL Gateway
    • 7.154.6 Features
    • 7.154.7 APEX RESTful Services
    • 7.154.8 Run Standalone Mode
    • 7.154.9 ORDS Users
    • 7.154.10 Summary
  • 7.155 Install SQL Translator
    • 7.155.1 Installing a Translator and Creating a Profile: Usage Notes
  • 7.156 Invalid Database Version
  • 7.157 Load Extension
  • 7.158 Load Keyboard Scheme
  • 7.159 LOB Descriptors
  • 7.160 Maintain Spatial Metadata
  • 7.161 Manage Columns
  • 7.162 Manage Connections (REST)
  • 7.163 Manage Features and Updates
  • 7.164 Map Connection
  • 7.165 Merge Migration Projects
  • 7.166 Modify Pluggable State
  • 7.167 Modify Value
  • 7.168 Data Move Details
  • 7.169 New/Edit Change Set
  • 7.170 New Procedure (Refactoring)
  • 7.171 New/Edit Local or Remote Port Forward
  • 7.172 Edit SSH Connection
  • 7.173 No Lock
  • 7.174 No Object Found
  • 7.175 No Object Selected
  • 7.176 Object Preferences
  • 7.177 Offline Generation Error - Destination Directory
  • 7.178 Open File
  • 7.179 Oracle-Only Report
  • 7.180 Paste
  • 7.181 Perforce: Add Files to Perforce
  • 7.182 Perforce: Connection
  • 7.183 Perforce: Create Changelist
  • 7.184 Perforce: Delete Files
  • 7.185 Perforce: Login
  • 7.186 Perforce: Open Files for Edit
  • 7.187 Perforce: Revert Files
  • 7.188 Perforce: Sync Files
  • 7.189 Perforce: Submit Changelist
  • 7.190 Plug In Pluggable Database
  • 7.191 Print Preview
  • 7.192 Privilege Warning for Migration
  • 7.193 Publish to REST
  • 7.194 Recent Files
  • 7.195 Delete or Truncate Repository
    • 7.195.1 Error Truncating Repository
  • 7.196 Rename Local Variable
  • 7.197 Rename Tab
  • 7.198 Rename Procedure
  • 7.199 Repair (Validate) Oracle REST Data Services
  • 7.200 REST Data Services Connection
  • 7.201 REST Data Services Connection: Authentication Failed
  • 7.202 REST Data Services Connection: Remove Connection
  • 7.203 RESTful Services Wizard (Auto-Enable REST Access)
    • 7.203.1 Specify Details
    • 7.203.2 RESTful Summary
  • 7.204 RESTful Services Wizard and Object Dialog Boxes
    • 7.204.1 Resource Module
    • 7.204.2 Resource Template
    • 7.204.3 Resource Handler
      • 7.204.3.1 Resource Handler Editing Pane
    • 7.204.4 RESTful Summary
  • 7.205 RESTful Services Connection
  • 7.206 RESTful Services Privilege
  • 7.207 RESTful Services Roles
  • 7.208 Select Current Repository
  • 7.209 Cannot Capture Table
  • 7.210 Report Panel
  • 7.211 Reset Expired Password (Enter New Password)
  • 7.212 Revision Lister
  • 7.213 Run/Debug/Profile PL/SQL
  • 7.214 Create/Edit Breakpoint
    • 7.214.1 Definition tab
    • 7.214.2 Conditions tab
    • 7.214.3 Actions tab
  • 7.215 Save/Save As, or Select File
  • 7.216 Save or Open Cart Tool Configuration
  • 7.217 Save Files
  • 7.218 Unable to Save Files
  • 7.219 Save Style Settings
  • 7.220 Schema Differences Source or Destination Error
  • 7.221 Script Execution Failed
  • 7.222 Script Generation Complete
  • 7.223 Set Data Mapping
  • 7.224 Add/Edit Rule
  • 7.225 Set Encoding
  • 7.226 Set Pause Continue
  • 7.227 Shared Wizard Pages
    • 7.227.1 Types
    • 7.227.2 Specify Objects
    • 7.227.3 Data
    • 7.227.4 Summary
  • 7.228 Sign In (checking for updates)
  • 7.229 Single Record View
  • 7.230 Save Snippet (User-Defined)
  • 7.231 Edit Snippets (User-Defined)
  • 7.232 Show SQL
  • 7.233 Start Date, End Date, Repeat Interval, Comments (Scheduler)
  • 7.234 Subversion: Add Property
  • 7.235 Subversion: Add to Source Control
  • 7.236 Subversion: Apply Patch
  • 7.237 Subversion: Branch/Tag
  • 7.238 Subversion: Check Out from Subversion
  • 7.239 Subversion: Commit Resources
  • 7.240 Subversion: Commit Working Copy
  • 7.241 Subversion: Confirm Checkout
  • 7.242 Subversion: Create Remote Directory
  • 7.243 Subversion: Create Subversion Repository
  • 7.244 Subversion: Create/Edit Subversion Connection
  • 7.245 Subversion: Delete Resources
  • 7.246 Subversion: Edit Configuration File
  • 7.247 Subversion: Export Files
  • 7.248 Subversion: Export Subversion Connections
  • 7.249 Subversion: Ignore
  • 7.250 Subversion: Import Subversion Connections
  • 7.251 Subversion: Import to Subversion
    • 7.251.1 Destination
    • 7.251.2 Source
    • 7.251.3 Filters
    • 7.251.4 Options
    • 7.251.5 Summary
  • 7.252 Subversion: Lock Resources
  • 7.253 Subversion: Merge
  • 7.254 Subversion: Pending Changes
  • 7.255 Subversion: Properties
  • 7.256 Subversion: Remove from Subversion
  • 7.257 Subversion: Repository Browser
  • 7.258 Subversion: Revert Local Changes
  • 7.259 Subversion: Switch
  • 7.260 Subversion: Unlock Resources
  • 7.261 Subversion: Update Resources
  • 7.262 Subversion: Update Working Copy
  • 7.263 Subversion: Versioning Properties
  • 7.264 Third-Party Database Objects
  • 7.265 Unable to Connect
  • 7.266 Unable to Open File
  • 7.267 Uninstall Oracle REST Data Services
  • 7.268 Unit Testing: Action Required
  • 7.269 Unit Testing: Add Category
  • 7.270 Unit Testing: Add Data Type
  • 7.271 Unit Testing: Add Item to Library
  • 7.272 Unit Testing: Add Test Implementation
  • 7.273 Unit Testing: Add Test Suite
  • 7.274 Unit Testing: Add Tests or Suites to a Suite
  • 7.275 Unit Testing: Copy or Rename Unit Test
  • 7.276 Unit Testing: Create Unit Test
    • 7.276.1 Select Operation
    • 7.276.2 Specify Test Name
    • 7.276.3 Specify Startup
    • 7.276.4 Specify Parameters
    • 7.276.5 Specify Validations
    • 7.276.6 Specify Teardown
    • 7.276.7 Summary
  • 7.277 Unit Testing: Manage Users
  • 7.278 Unit Testing: Rename Test Implementation
  • 7.279 Unit Testing: Result of Operation
  • 7.280 Unit Testing: Synchronize Unit Test
  • 7.281 Unplug Pluggable Database
  • 7.282 Unsupported Database Version
  • 7.283 Validate Geometry
  • 7.284 View Whole Value
  • 7.285 Windows
  • 7.286 XMLType Column Properties