1/71

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Changes in This Release

• Changes in Oracle Application Express Release 18.1
  • New Features
  • Deprecated and Desupported Features
  • Other Changes

1 Getting Started with SQL Workshop

• 1.1 SQL Workshop Home Page
• 1.2 Selecting a Schema

2 Managing Database Objects with Object Browser

• 2.1 Accessing Object Browser
• 2.2 Object Browser
• 2.3 Searching for and Browsing Database Objects
• 2.4 Searching For and Selecting Database Objects
• 2.5 Hiding the Object Selection Pane
• 2.6 Creating Database Objects
• 2.7 Managing Tables
  • 2.7.1 Creating a Table
  • 2.7.2 Browsing a Table
  • 2.7.3 Reports Available for Tables
  • 2.7.4 Editing a Table
  • 2.7.5 Dropping a Table
• 2.8 Managing Views
  • 2.8.1 Creating a View
  • 2.8.2 Browsing a View
  • 2.8.3 Reports for Views
  • 2.8.4 Editing a View Manually
  • 2.8.5 Using Find and Replace
  • 2.8.6 Downloading a View
  • 2.8.7 Compiling a View
  • 2.8.8 Dropping a View
• 2.9 Managing Indexes
  • 2.9.1 Creating an Index
  • 2.9.2 Browsing an Index
  • 2.9.3 Reports for Indexes
  • 2.9.4 Dropping an Index
• 2.10 Managing Sequences
  • 2.10.1 Creating a Sequence
  • 2.10.2 Browsing a Sequence
  • 2.10.3 Reports for Sequences
  • 2.10.4 Dropping a Sequence
  • 2.10.5 Altering a Sequence
• 2.11 Managing Types
  • 2.11.1 Creating a Type
  • 2.11.2 Browsing a Type
  • 2.11.3 Reports for Types
  • 2.11.4 Dropping a Type
• 2.12 Managing Packages
  • 2.12.1 Creating a Package
  • 2.12.2 Viewing a Package
  • 2.12.3 Reports for Packages
  • 2.12.4 Editing a Package Manually
  • 2.12.5 Compiling a Package
  • 2.12.6 Downloading a Package
  • 2.12.7 Dropping a Package While Viewing Specification
  • 2.12.8 Dropping a Package While Viewing the Body
• 2.13 Managing Procedures
  • 2.13.1 Creating a Procedure
  • 2.13.2 Browsing a Procedure
  • 2.13.3 Reports for Procedures
  • 2.13.4 Editing a Procedure
    • 2.13.4.1 Editing a Procedure Manually
  • 2.13.5 Compiling a Procedure
  • 2.13.6 Downloading a Procedure
  • 2.13.7 Dropping a Procedure
• 2.14 Managing Functions
  • 2.14.1 Creating a Function
  • 2.14.2 Browsing a Function
  • 2.14.3 Reports for Functions
  • 2.14.4 Editing a Function Manually
  • 2.14.5 Compiling a Function
  • 2.14.6 Downloading a Function
  • 2.14.7 Dropping a Function
• 2.15 Managing Triggers
  • 2.15.1 Creating Triggers
  • 2.15.2 Browsing a Trigger
  • 2.15.3 Reports for Triggers
  • 2.15.4 Editing a Trigger Manually
  • 2.15.5 Compiling a Trigger
  • 2.15.6 Downloading a Trigger
  • 2.15.7 Dropping a Trigger
  • 2.15.8 Disabling and Enabling a Trigger
• 2.16 Managing Database Links
  • 2.16.1 Creating a Database Link
  • 2.16.2 Browsing a Database Link
  • 2.16.3 Reports for Database Links
  • 2.16.4 Dropping a Database Link
• 2.17 Managing Materialized Views
  • 2.17.1 Creating a Materialized View
  • 2.17.2 Browsing a Materialized View
  • 2.17.3 Reports for Materialized Views
  • 2.17.4 Dropping a Materialized View
• 2.18 Managing Synonyms
  • 2.18.1 Creating Synonyms
  • 2.18.2 Viewing a Synonym
  • 2.18.3 Dropping a Synonym

3 Using SQL Commands

• 3.1 About SQL Commands
• 3.2 Accessing SQL Commands
• 3.3 About the SQL Commands Home Page
• 3.4 Using the Command Editor
  • 3.4.1 Running a SQL Command
  • 3.4.2 About Transactions in SQL Commands
  • 3.4.3 Disabling Transactional SQL Commands
  • 3.4.4 Enabling Transactional SQL Commands
  • 3.4.5 About Unsupported SQL*Plus Commands
  • 3.4.6 Terminating a Command
  • 3.4.7 Using Bind Variables
  • 3.4.8 Using the Find Tables Button
• 3.5 Saving an SQL Command
• 3.6 Copying a Command
• 3.7 Viewing Results
  • 3.7.1 Accessing the Results Pane
  • 3.7.2 About the Results Pane
• 3.8 Using Explain Plan
  • 3.8.1 Viewing an Explain Plan
• 3.9 Using Saved Commands
  • 3.9.1 Accessing Saved Commands
  • 3.9.2 About the Saved SQL Pane
• 3.10 Using SQL Command History
  • 3.10.1 Accessing a Command from Command History
  • 3.10.2 About the History Pane

4 Using Oracle Application Express Utilities

• 4.1 Using Data Workshop
  • 4.1.1 About the Data Load and Unload Wizards
  • 4.1.2 About Importing, Exporting, Loading, and Unloading Data
  • 4.1.3 Import/Export/Load/Unload Options
  • 4.1.4 Accessing the Data Load/Unload Page
  • 4.1.5 Loading Data
    • 4.1.5.1 About Loading Data
    • 4.1.5.2 Loading a Text File or Spreadsheet Data
    • 4.1.5.3 Loading an XML Document
  • 4.1.6 Unloading Data
    • 4.1.6.1 Unloading a Text File
    • 4.1.6.2 Unloading to an XML Document
  • 4.1.7 Using the Repository
• 4.2 Using Query Builder
  • 4.2.1 Query Builder Home Page
  • 4.2.2 Accessing Query Builder
  • 4.2.3 Understanding the Query Building Process
  • 4.2.4 Using the Object Selection Pane
    • 4.2.4.1 Searching and Filtering Objects
    • 4.2.4.2 Hiding and Restoring the Object Selection Pane
    • 4.2.4.3 Selecting Objects
  • 4.2.5 Using the Design Pane
    • 4.2.5.1 About Supported Column Types
    • 4.2.5.2 Adding an Object to the Design Pane
    • 4.2.5.3 Resizing the Design and Results Panes
    • 4.2.5.4 Removing or Hiding Objects in the Design Pane
  • 4.2.6 Specifying Query Conditions
  • 4.2.7 Creating Relationships Between Objects
    • 4.2.7.1 About Join Conditions
    • 4.2.7.2 Joining Objects Manually
    • 4.2.7.3 Joining Objects Automatically
  • 4.2.8 Working with Saved Queries
    • 4.2.8.1 Saving a Query
    • 4.2.8.2 Editing a Saved Query
    • 4.2.8.3 Deleting a Saved Query
  • 4.2.9 Viewing Generated SQL
  • 4.2.10 Viewing Query Results
• 4.3 Using Quick SQL
  • 4.3.1 Getting Started with Quick SQL
    • 4.3.1.1 About Quick SQL
    • 4.3.1.2 About Quick SQL Shorthand Syntax
    • 4.3.1.3 Accessing Quick SQL
  • 4.3.2 Using Quick SQL Help
    • 4.3.2.1 Accessing Quick SQL Help
    • 4.3.2.2 About Quick SQL Help
  • 4.3.3 Generating Quick SQL with SQL Shorthand
  • 4.3.4 Saving Scripts
    • 4.3.4.1 Saving a SQL Script
    • 4.3.4.2 Downloading SQL Script
  • 4.3.5 Creating an Application from a Generated SQL Script
  • 4.3.6 Using Quick SQL Samples
    • 4.3.6.1 About Quick SQL Samples
    • 4.3.6.2 Accessing Quick SQL Samples
  • 4.3.7 Configuring Settings
    • 4.3.7.1 About Settings
    • 4.3.7.2 Configuring Settings Declaratively
    • 4.3.7.3 Configuring Settings Inline
  • 4.3.8 About Database Terminology
  • 4.3.9 Recommendations When Using Quick SQL
  • 4.3.10 About Supported Data Types
• 4.4 Using Sample Datasets
  • 4.4.1 About Sample Datasets
  • 4.4.2 Accessing Sample Datasets
  • 4.4.3 Installing a Sample Dataset
  • 4.4.4 Removing a Sample Dataset
  • 4.4.5 Refreshing a Sample Dataset
  • 4.4.6 Changing the Schema for a Sample Dataset
• 4.5 Generating DDL
• 4.6 Managing User Interface Defaults
  • 4.6.1 About User Interface Defaults
  • 4.6.2 Creating User Interface Defaults for a Table
  • 4.6.3 Modifying Table User Interface Defaults
  • 4.6.4 Creating User Interface Attributes
  • 4.6.5 Modifying User Interface Attributes
  • 4.6.6 Exporting and Importing User Interface Defaults
• 4.7 Comparing Schemas
• 4.8 Managing Methods on Tables
• 4.9 Using the Recycle Bin
  • 4.9.1 Managing Objects in the Recycle Bin
  • 4.9.2 Emptying the Recycle Bin Without Viewing the Objects
• 4.10 Viewing Object Reports
  • 4.10.1 Viewing Table Reports
  • 4.10.2 Viewing PL/SQL Reports
    • 4.10.2.1 Viewing Package Input and Output Parameters
    • 4.10.2.2 Viewing the Number of Lines of Code for an Object
    • 4.10.2.3 Searching PL/SQL Source Code
  • 4.10.3 Viewing Exception Reports
  • 4.10.4 Viewing Security Reports
  • 4.10.5 Viewing All Object Reports
• 4.11 Viewing Database Details
• 4.12 Monitoring the Database
  • 4.12.1 Accessing Session Page Reports
    • 4.12.1.1 Accessing Reports on the Session Page
    • 4.12.1.2 Creating Sessions Reports
    • 4.12.1.3 Controlling the Number of Rows for Locks Reports
    • 4.12.1.4 Creating Waits Reports
    • 4.12.1.5 Creating I/O Reports
    • 4.12.1.6 Creating SQL Reports
    • 4.12.1.7 Creating Open Cursors Report
  • 4.12.2 System Statistics
  • 4.12.3 Viewing System Statistics
  • 4.12.4 About Top SQL Page
  • 4.12.5 Viewing Top SQL Page
  • 4.12.6 About Long Operations Page
  • 4.12.7 Viewing the Long Operations Page

5 Using SQL Scripts

• 5.1 About SQL Scripts
• 5.2 Accessing SQL Scripts
• 5.3 About the SQL Scripts Page
• 5.4 About the Tasks List
• 5.5 Creating a SQL Script
  • 5.5.1 Creating a SQL Script in the Script Editor
  • 5.5.2 Uploading a SQL Script
• 5.6 Using the Script Editor
  • 5.6.1 Editing an Existing Script
  • 5.6.2 Script Editor Controls
• 5.7 Deleting a SQL Script
  • 5.7.1 Deleting Scripts from the SQL Scripts Page
  • 5.7.2 Deleting a Script in the Script Editor
• 5.8 Copying a SQL Script
• 5.9 Executing a SQL Script
  • 5.9.1 Executing a SQL Script in the Script Editor
  • 5.9.2 Executing a SQL Script from the SQL Scripts Page
• 5.10 Viewing SQL Script Results
• 5.11 Exporting and Importing SQL Scripts
  • 5.11.1 Copying Scripts to an Export Script
  • 5.11.2 Importing Scripts
• 5.12 Viewing Script and Result Quotas

6 Enabling Data Exchange with RESTful Services

• 6.1 What Is REST?
• 6.2 About Oracle RESTful Services
• 6.3 RESTful Service Requirements
• 6.4 How to Access RESTful Services
  • 6.4.1 Accessing RESTful Services
  • 6.4.2 Registering Schema with ORDS
  • 6.4.3 About ORDS RESTful Services Dashboard
• 6.5 How to Create the ORDS Based RESTful Services Module Example
  • 6.5.1 About the Example RESTful Service Module (oracle.example.hr)
  • 6.5.2 Returning the Result Set Based on a PL/SQL Block (empsecformat/:empname)
  • 6.5.3 Returning the Result Set in JSON Format with Pagination Set (employees/)
  • 6.5.4 Retrieving Data Based on a Parameter (employees/:id)
  • 6.5.5 Returning the Result Set in CSV Format (empinfo/)
  • 6.5.6 Returning the Result Set as a Feed (employeesfeed/)
• 6.6 Managing RESTful Service Modules
  • 6.6.1 Installing a Sample RESTful Service Module with Schema ORDS not Enabled
  • 6.6.2 Installing a Sample RESTful Service Module with Schema ORDS Enabled
  • 6.6.3 Creating an ORDS RESTful Service Module
  • 6.6.4 Editing an ORDS RESTful Service Module
  • 6.6.5 Deleting an ORDS RESTful Service Module
  • 6.6.6 Managing an ORDS RESTful Service Privileges
  • 6.6.7 Assigning Privileges to an ORDS RESTful Service Modules
  • 6.6.8 Creating an ORDS RESTful Service Privilege
  • 6.6.9 Editing an RESTful Service Privilege
  • 6.6.10 Deleting an ORDS RESTful Service Privilege
  • 6.6.11 Exporting an ORDS RESTful Service Module
  • 6.6.12 Importing an ORDS RESTful Service Module
  • 6.6.13 Generating a Swagger Document
• 6.7 Managing Resource Templates
  • 6.7.1 Adding a Resource Template
  • 6.7.2 Editing a Resource Template
  • 6.7.3 Deleting a Resource Template
• 6.8 Managing Resource Handlers
  • 6.8.1 Adding a Resource Handler
  • 6.8.2 Editing a Resource Handler
  • 6.8.3 Deleting a Resource Handler

Index