Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Product Accessibility
  • Related Documents
  • Conventions
  • Third-Party License Information
• 1 Changes in Release 22.3 for Using Oracle Database Actions
• 2 About Oracle Database Actions
  • 2.1 About the Database Actions User Interface
    • 2.1.1 Using the Omnisearch Bar
  • 2.2 Accessing Database Actions
  • 2.3 The Home Page - Launchpad
• Part I Development
  • 3 The SQL and Data Modeler Pages
    • 3.1 The Overview Page
    • 3.2 The SQL Page
      • 3.2.1 Object Navigator and Files
      • 3.2.2 Executing SQL Statements in the Code Editor
        • 3.2.2.1 About Session State in Database Actions
        • 3.2.2.2 Keyboard Shortcuts
        • 3.2.2.3 Support for Multilingual Engine
      • 3.2.3 Viewing the SQL Output
        • 3.2.3.1 Using the Explain Plan Diagram
      • 3.2.4 Loading Data
        • 3.2.4.1 Loading Data from a Local File to a New Table
        • 3.2.4.2 Loading Data from a Local File to an Existing Table
        • 3.2.4.3 Loading Data from Multiple Local Files into Mutiple Tables
        • 3.2.4.4 Format Specifications for JSON, AVRO, and XML Files
          • 3.2.4.4.1 JSON and AVRO Files
          • 3.2.4.4.2 XML Files
    • 3.3 The Data Modeler Page
      • 3.3.1 Navigating Diagrams and Objects
      • 3.3.2 About the Data Modeler Editor
        • 3.3.2.1 About Viewing JSON Data Guides
    • 3.4 Creating and Editing Database Objects
      • 3.4.1 The Table Properties Dialog
        • 3.4.1.1 Columns Pane
        • 3.4.1.2 Primary Key Pane
        • 3.4.1.3 Unique Keys Pane
        • 3.4.1.4 Indexes Pane
        • 3.4.1.5 Foreign Keys Pane
        • 3.4.1.6 Table Constraints Pane
        • 3.4.1.7 Comments Pane
        • 3.4.1.8 Storage Pane
        • 3.4.1.9 External Table Properties Pane
        • 3.4.1.10 Materialized View Pane
        • 3.4.1.11 DDL Pane
        • 3.4.1.12 Output Pane
      • 3.4.2 The Index Properties Dialog
      • 3.4.3 The Sequence Properties Dialog
      • 3.4.4 The View Properties Dialog
      • 3.4.5 The Synonym Properties Dialog
      • 3.4.6 The Materialized View Log Properties Dialog
      • 3.4.7 Implied Foreign Keys
  • 4 The REST Pages
    • 4.1 About RESTful Web Services
    • 4.2 RESTful Services Terminology
    • 4.3 About the Overview Page
    • 4.4 About the AutoREST Page
      • 4.4.1 Enabling REST Access for a Database Object
      • 4.4.2 Disabling REST Access for a Database Object
      • 4.4.3 Generating cURL Requests for a REST-Enabled Database Object
    • 4.5 About the REST Search Toolbar
    • 4.6 Creating RESTful Web Services
      • 4.6.1 Managing Resource Modules
        • 4.6.1.1 Creating a Resource Module
        • 4.6.1.2 Importing a Resource Module
        • 4.6.1.3 Editing a Resource Module
        • 4.6.1.4 Deleting a Resource Module
        • 4.6.1.5 Publishing/Unpublishing a Resource Module
        • 4.6.1.6 Exporting a Resource Module
        • 4.6.1.7 Viewing the Module in OpenAPI View
      • 4.6.2 Managing Resource Templates
        • 4.6.2.1 Creating a Resource Template
        • 4.6.2.2 Editing a Resource Template
        • 4.6.2.3 Deleting a Resource Template
      • 4.6.3 Managing Resource Handlers
        • 4.6.3.1 Creating a Resource Handler
        • 4.6.3.2 Editing a Resource Handler
        • 4.6.3.3 Deleting a Resource Handler
      • 4.6.4 Example: Inserting a Record using a POST Handler
      • 4.6.5 Viewing Resource Handler Details and Managing Parameters
        • 4.6.5.1 Creating a Parameter
        • 4.6.5.2 Editing a Parameter
        • 4.6.5.3 Deleting a Parameter
        • 4.6.5.4 Implicit Parameters
    • 4.7 Securing RESTful Web Services
      • 4.7.1 Managing Roles
        • 4.7.1.1 Creating a Role
        • 4.7.1.2 Editing a Role
        • 4.7.1.3 Deleting a Role
        • 4.7.1.4 Viewing Assigned Privileges
      • 4.7.2 Managing Privileges
        • 4.7.2.1 Creating a Privilege
        • 4.7.2.2 Editing a Privilege
        • 4.7.2.3 Deleting a Privilege
      • 4.7.3 Managing OAuth Clients
        • 4.7.3.1 Creating an OAuth Client
        • 4.7.3.2 Editing an OAuth Client
        • 4.7.3.3 Deleting an OAuth Client
      • 4.7.4 Example: Creating an OAuth Client
  • 5 The Liquibase Page
    • 5.1 Generate a Deployment
    • 5.2 About the Liquibase User Interface
  • 6 The Charts and Dashboards Page
    • 6.1 Overview
    • 6.2 Creating or Editing a Chart
    • 6.3 Example: Creating and Editing a Chart
    • 6.4 Creating or Editing a Dashboard
  • 7 The JSON Page
    • 7.1 About the JSON User Interface
    • 7.2 Managing JSON Collections
      • 7.2.1 Creating a Collection
      • 7.2.2 About Adding or Editing a JSON Document
        • 7.2.2.1 About Database Differences in JSON Documents
    • 7.3 About Querying Documents in a Collection
      • 7.3.1 Using the In-Context Autocomplete Feature in the JSON Editor
    • 7.4 Creating Indexes for JSON Collections
    • 7.5 Creating Relational Views of JSON Documents
    • 7.6 Viewing the JSON Data Guide Diagram for a Collection
  • 8 The Scheduling Pages
    • 8.1 Overview
    • 8.2 Jobs
      • 8.2.1 Summary
      • 8.2.2 Running
      • 8.2.3 History
      • 8.2.4 Forecast
      • 8.2.5 History (Gantt Chart)
      • 8.2.6 Notifications
      • 8.2.7 Create or Edit Job
    • 8.3 Chains
      • 8.3.1 Create or Edit Chain
      • 8.3.2 Add or Edit Step
      • 8.3.3 Add or Edit Rule
    • 8.4 Programs
      • 8.4.1 Create or Edit Program
    • 8.5 Schedules
      • 8.5.1 Create or Edit Schedule
    • 8.6 Objects
      • 8.6.1 Create Job Class
      • 8.6.2 Create File Watcher
      • 8.6.3 Create Window
      • 8.6.4 Create Window Group
• Part II Administration
  • 9 The Database Users Page
    • 9.1 About Create/Edit User
    • 9.2 About REST Enable User
    • 9.3 About Delete User
  • 10 The APEX Workspaces Page
    • 10.1 Create a Workspace
  • The Data Pump Page
    • Import Data Using Oracle Data Pump
• Part III Monitoring
  • 11 The Monitoring Overview Page
  • 12 The Performance Hub Page
  • 13 The Instance Viewer Page
  • 14 The Logins Page
  • 15 The Alerts Page
  • 16 The Sessions Page
  • 17 The Storage Page
  • 18 The Parameters Page
  • 19 The Real Time SQL Monitoring Page
  • 20 The Top SQL Page
  • 21 The Waits Page
  • 22 The AWR Page
• A Supported SQL*Plus and SQLcl Commands
  • A.1 Supported SQL*Plus Commands
  • A.2 Supported SQLcl Commands
    • A.2.1 SODA Commands