Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Product Accessibility
  • Related Documents
  • Conventions
  • Third-Party License Information
• 1 Changes in Release 21.1 for Using Oracle Database Actions
• 2 About Oracle Database Actions
  • About the Database Actions User Interface
  • Accessing Oracle Database Actions
  • The Home Page - Launchpad
• 3 The SQL and Data Modeler Pages
  • The Overview Page
  • The SQL Page
    • Navigating Objects and Worksheets
    • Executing SQL Statements in the Code Editor
      • Keyboard Shortcuts
    • Viewing the SQL Output
    • Loading Data
      • Loading Data from a Local File to a New Table
      • Loading Data from a Local File to an Existing Table
      • Format Specifications for JSON, AVRO, and XML Files
        • JSON and AVRO Files
        • XML Files
  • The Data Modeler Page
    • Navigating Diagrams and Objects
    • About the Data Modeler Editor
      • About Viewing JSON Data Guides
  • Creating and Editing Database Objects
    • The Table Properties Dialog
      • Columns Pane
      • Primary Key Pane
      • Unique Keys Pane
      • Indexes Pane
      • Foreign Keys Pane
      • Table Constraints Pane
      • Comments Pane
      • Storage Pane
      • External Table Properties Pane
      • Materialized View Pane
      • DDL Pane
      • Output Pane
    • The Index Properties Dialog
    • The Sequence Properties Dialog
    • The View Properties Dialog
    • The Synonym Properties Dialog
    • The Materialized View Log Properties Dialog
    • Implied Foreign Keys
• 4 The REST Pages
  • About RESTful Web Services
  • RESTful Services Terminology
  • About the Overview Page
  • About the AutoREST Page
    • Enabling REST Access for a Database Object
    • Disabling REST Access for a Database Object
    • Generating cURL Requests for a REST-Enabled Database Object
  • About the REST Search Toolbar
  • Creating RESTful Web Services
    • Managing Resource Modules
      • Creating a Resource Module
      • Editing a Resource Module
      • Deleting a Resource Module
      • Publishing/Unpublishing a Resource Module
      • Exporting a Resource Module
    • Managing Resource Templates
      • Creating a Resource Template
      • Editing a Resource Template
      • Deleting a Resource Template
    • Managing Resource Handlers
      • Creating a Resource Handler
      • Editing a Resource Handler
      • Deleting a Resource Handler
    • Example: Inserting a Record using a POST Handler
    • Viewing Resource Handler Details and Managing Parameters
      • Creating a Parameter
      • Editing a Parameter
      • Deleting a Parameter
  • Securing RESTful Web Services
    • Managing Roles
      • Creating a Role
      • Editing a Role
      • Deleting a Role
      • Viewing Assigned Privileges
    • Managing Privileges
      • Creating a Privilege
      • Editing a Privilege
      • Deleting a Privilege
    • Managing OAuth Clients
      • Creating an OAuth Client
      • Editing an OAuth Client
      • Deleting an OAuth Client
    • Example: Creating an OAuth Client
• 5 The JSON Page
  • About the JSON User Interface
  • Managing JSON Collections
    • Creating a Collection
    • About Adding or Editing a JSON Document
  • About Querying Documents in a Collection
    • Using the In-Context Autocomplete Feature in the JSON Editor
  • Managing JSON Search Indexes for a Collection
  • Viewing the JSON Data Guide Diagram for a Collection
• 6 The Database Users Page
  • About Create/Edit User
  • About REST Enable User
  • About Delete User
• 7 The Monitoring Pages
  • The Monitoring Overview Page
  • The Performance Hub Page
  • The Instance Viewer Page
  • The Logins Page
  • The Alerts Page
  • The Sessions Page
  • The Storage Page
  • The Parameters Page
  • The Real Time SQL Monitoring Page
  • The Top SQL Page
  • The Waits Page
• A Supported SQL*Plus and SQLcl Commands
  • Supported SQL*Plus Commands
  • Supported SQLcl Commands
    • SODA Commands