Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Related Documents
  • Conventions
• Changes in This Release
  • Deprecated and Desupported Features
• Getting Started with SQL Workshop
  • SQL Workshop Home Page
  • Selecting a Schema
• Managing Database Objects with Object Browser
  • Accessing Object Browser
  • Understanding Object Browser
    • About Object Tree and Object Detail View
      • About the Object Tree Context Menus
      • Common Object Browser Behaviors
    • Selecting Objects and Viewing Object Details
      • Object Detail View
      • Object Tabs and Actions
    • Filtering Objects in the Object Tree
    • Hiding or Resizing the Object Tree
    • Code Editor in Object Browser
      • Command Palette
      • Settings Menu
    • Creating Database Objects
  • Managing Tables
    • Creating a Table
    • Viewing a Table
    • Editing Table Columns
    • Editing Table Data
    • Dropping a Table
    • Creating an Application from a Table
    • Analyzing Statistics of a Table
    • Viewing Sample Queries for a Table
  • Managing Views
    • Creating a View
    • Viewing a View
    • Editing a View Manually
    • Downloading a View
    • Compiling a View
    • Dropping a View
  • Managing Indexes
    • Creating an Index
    • Viewing an Index
    • Dropping an Index
  • Managing Sequences
    • Creating a Sequence
    • Browsing a Sequence
    • Dropping a Sequence
  • Managing Types
    • Creating a Type
    • Viewing a Type
    • Dropping a Type
  • Managing Packages
    • Creating a Package
    • Viewing a Package
    • Editing a Package Manually
    • Compiling a Package
    • Downloading a Package
    • Dropping a Package While Viewing the Specification
    • Dropping a Package While Viewing the Body
  • Managing Procedures
    • Creating a Procedure
    • Viewing a Procedure
    • Editing a Procedure
    • Compiling a Procedure
    • Downloading a Procedure
    • Dropping a Procedure
  • Managing Functions
    • Creating a Function
    • Viewing a Function
    • Editing a Function
    • Compiling a Function
    • Downloading a Function
    • Dropping a Function
  • Managing Triggers
    • Creating a Trigger
    • Viewing a Trigger
    • Editing a Trigger
    • Compiling a Trigger
    • Downloading a Trigger
    • Disabling and Enabling a Trigger
    • Dropping a Trigger
  • Managing Database Links
    • Creating a Database Link
    • Viewing a Database Link
    • Dropping a Database Link
  • Managing Materialized Views
    • Browsing a Materialized View
    • Dropping a Materialized View
  • Managing Synonyms
    • Creating Synonyms
    • Viewing a Synonym
    • Dropping a Synonym
  • Managing SODA Collections
    • About SODA Collections
      • Requirements
      • Supported Filetypes
    • Creating a SODA Collection
    • Viewing a SODA Collection
    • Editing or Dropping a SODA Collection
• Using SQL Commands
  • About SQL Commands
  • Accessing SQL Commands
  • About the SQL Commands Home Page
    • Command Editor
    • Display Pane
  • Using the Command Editor
    • Running a SQL Command
    • About Transactions in SQL Commands
    • About Unsupported SQL*Plus Commands
    • Terminating a Command
    • Using Bind Variables
    • Using the Find Tables Button
  • Saving an SQL Command
  • Copying a Command
  • Viewing Results
    • Accessing the Results Pane
    • About the Results Pane
  • Using Explain Plan
    • Viewing an Explain Plan
  • Using Saved Commands
    • Accessing Saved Commands
    • About the Saved SQL Pane
  • Using SQL Command History
    • Accessing a Command from Command History
    • About the History Pane
• Using SQL Workshop Utilities
  • Using Data Workshop
    • About the Load Data and Unload Data Wizards
    • About Importing, Exporting, Loading, and Unloading Data
    • Import, Export, Load, and Unload Options
    • Accessing the Load Data and Unload Data Wizards
    • Loading Data
      • About Loading Data
      • Copying and Pasting CSV data or Selecting a Sample Data Set
      • Loading an XML Document
      • Loading a JSON File
      • Loading a XLSX File
    • Unloading Data
      • Unloading a Text File
      • Unloading to an XML Document
    • Loading Data From the Oracle Cloud (Autonomous Database Only)
      • Granting Privileges to the Workspace Schema
      • User Interface Differences for Oracle Cloud Users
      • About Object Store References
      • Creating an Object Store Reference
        • Required
        • Procedure
      • Creating an External Table from Cloud
      • Loading Avro or Parquet Files into Object Browser from Cloud
      • Loading Other Files into Object Browser from Cloud
  • Using Data Generator
    • About JSON Blueprints
      • Quick Table Inserts with Data Generator
    • Accessing Data Generator
    • Creating JSON Blueprints
      • Creating a Blueprint from Existing Tables
      • Creating a Blueprint from Scratch
      • Importing a Blueprint
    • Running JSON Blueprints
      • Selecting Data Generation Schema
      • Generating Data from a Blueprint
    • Modifying JSON Blueprints
      • About Blueprint Designer
      • Modifying Blueprint Table and Column Attributes
      • Adding and Deleting Tables and Columns
      • Saving Blueprints
    • Previewing JSON Blueprints
    • Exporting JSON Blueprints
    • Deleting JSON Blueprints
  • Using Quick SQL
    • Getting Started with Quick SQL
      • About Quick SQL
      • About Quick SQL Shorthand Syntax
        • About Settings
    • Accessing Quick SQL
    • About the Quick SQL Page
      • Quick SQL Pane
      • SQL Pane
    • Accessing Quick SQL Help
    • Loading Quick SQL Sample Models
      • About Quick SQL Sample Models
      • Loading a Quick SQL Sample Model
    • Generating SQL with SQL Shorthand Syntax
    • Managing Quick SQL Models and Scripts
      • Saving a Quick SQL Model
      • Loading a Saved Quick SQL Model
      • Saving a Quick SQL Model Under a Different Name
      • Deleting a Quick SQL Model
      • Viewing an Entity Relationship Diagram
      • Saving a Generated SQL Script
      • Downloading SQL Scripts
    • Creating an Application from a Generated SQL Script
    • Configuring Quick SQL Settings
      • Configuring Settings Declaratively
      • Configuring Settings Inline
    • Recommendations When Using Quick SQL
    • Database Terminology Used in Quick SQL
    • About Supported Data Types
  • Using Sample Datasets
    • About Sample Datasets
    • Accessing Sample Datasets
    • Installing a Sample Dataset
    • Refreshing a Sample Dataset
    • Changing the Schema for a Sample Dataset
    • Removing a Sample Dataset
  • Generating DDL
  • Describing Tables
  • Managing User Interface Defaults (UI Defaults)
    • About UI Defaults
    • Creating UI Defaults for a Table
    • Modifying Table UI Defaults
    • Creating UI Attributes
    • Modifying UI Attributes
    • Exporting and Importing UI Defaults
  • Comparing Schemas
  • Navigating to Data Dictionary Cache
  • Managing Methods on Tables
  • Using the Recycle Bin
    • Managing Objects in the Recycle Bin
    • Emptying the Recycle Bin Without Viewing the Objects
  • Viewing Object Reports
    • Viewing Table Reports
    • Viewing PL/SQL Reports
      • Viewing Package Input and Output Parameters
      • Viewing the Number of Lines of Code for an Object
      • Searching PL/SQL Source Code
    • Viewing Exception Reports
    • Viewing Security Reports
    • Viewing All Object Reports
  • Creating a Data Model Using AI
  • Viewing Database Details
  • Monitoring the Database
    • About Database Monitor Access Requirements
    • Accessing Session Page Reports
      • Accessing Reports on the Session Page
      • Creating Sessions Reports
      • Controlling the Number of Rows for Locks Reports
      • Creating Waits Reports
      • Creating I/O Reports
      • Creating SQL Reports
      • Creating Open Cursors Report
    • System Statistics
    • Viewing System Statistics
    • About Top SQL Page
    • Viewing Top SQL Page
    • About Long Operations Page
    • Viewing the Long Operations Page
• Using SQL Scripts
  • About SQL Scripts
  • Accessing SQL Scripts
  • About the SQL Scripts Page
  • About the Tasks List
  • Creating a SQL Script
    • Creating a SQL Script in the Script Editor
    • Uploading a SQL Script
  • Using the Script Editor
    • Editing an Existing Script
    • Script Editor Controls
  • Creating an Application from a Script
    • Required
    • Procedure
  • Deleting a SQL Script
    • Deleting Scripts from the SQL Scripts Page
    • Deleting a Script in the Script Editor
  • Copying a SQL Script
  • Executing a SQL Script
    • Executing a SQL Script in the Script Editor
    • Executing a SQL Script from the SQL Scripts Page
  • Viewing SQL Script Results
  • Exporting and Importing SQL Scripts
    • Exporting SQL Scripts
    • Importing Scripts
  • Viewing Script and Result Quotas
• Enabling Data Exchange with REST APIs
  • Managing Schema REST Access for SQL Developer Web
  • Accessing SQL Developer Web Directly from APEX
  • Related Resources