Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Product Accessibility
  • Related Documents
  • Conventions
  • Third-Party License Information
• 1 Changes in 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.2.1 Enabling User Access to Database Actions
  • 2.3 The Home Page - Launchpad
  • 2.4 About Session State in Database Actions
  • 2.5 Enabling Detailed Request Error Messages for a Specific Schema
• 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 JSON Page
    • 5.1 About the JSON User Interface
    • 5.2 Managing JSON Collections
      • 5.2.1 Creating a Collection
      • 5.2.2 About Adding or Editing a JSON Document
        • 5.2.2.1 About Database Differences in JSON Documents
    • 5.3 About Querying Documents in a Collection
      • 5.3.1 Using the In-Context Autocomplete Feature in the JSON Editor
    • 5.4 Creating Indexes for JSON Collections
    • 5.5 Creating Relational Views of JSON Documents
    • 5.6 Viewing the JSON Data Guide Diagram for a Collection
  • 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 Scheduling Pages
    • 7.1 Overview
    • 7.2 Jobs
      • 7.2.1 Summary
      • 7.2.2 Running
      • 7.2.3 History
      • 7.2.4 Forecast
      • 7.2.5 History (Gantt Chart)
      • 7.2.6 Notifications
      • 7.2.7 Create or Edit Job
    • 7.3 Chains
      • 7.3.1 Create or Edit Chain
      • 7.3.2 Add or Edit Step
      • 7.3.3 Add or Edit Rule
    • 7.4 Programs
      • 7.4.1 Create or Edit Program
    • 7.5 Schedules
      • 7.5.1 Create or Edit Schedule
    • 7.6 Objects
      • 7.6.1 Create Job Class
      • 7.6.2 Create File Watcher
      • 7.6.3 Create Window
      • 7.6.4 Create Window Group
  • 8 The Liquibase Page
    • 8.1 Generate a Deployment
    • 8.2 About the Liquibase User Interface
• Part II Monitoring
  • The Monitoring Overview Page
  • The Performance Hub Page
  • The Alerts Page
  • The Sessions Page
  • The Storage Page
  • The Parameters Page
  • The Database Dashboard Page
    • Database Monitor Overview
    • Database Monitor Activity
  • The AWR Page
• Part III Data Studio
  • 9 The Data Studio Overview Page
  • 10 The Data Load Page
    • 10.1 Checking Data Load Jobs
    • 10.2 Managing Cloud Storage Connections
      • 10.2.1 Create Oracle Cloud Infrastructure Native Credentials
    • 10.3 Loading Data
      • 10.3.1 Loading Data From Local Files
      • 10.3.2 Loading Data from Other Databases
      • 10.3.3 Loading Data from Cloud Storage
        • 10.3.3.1 Manage Cloud Storage Links for Data Load Jobs
        • 10.3.3.2 Prepare the Data Load Job
        • 10.3.3.3 Add Files or Folders for the Data Load Job
        • 10.3.3.4 Enter Details for the Data Load Job
        • 10.3.3.5 Run the Data Load Job
        • 10.3.3.6 View Details About the Data Load Job After It Is Run
        • 10.3.3.7 View the Table Resulting from the Data Load Job
    • 10.4 Linking Data
      • 10.4.1 Linking to Other Databases
      • 10.4.2 Linking to Objects in Cloud Storage
        • 10.4.2.1 Manage Cloud Storage Links for Data Link Jobs
        • 10.4.2.2 Prepare the Data Link Job
        • 10.4.2.3 Add Files or Folders for the Data Link Job
        • 10.4.2.4 Enter Details for the Data Link Job
        • 10.4.2.5 Run the Data Link Job
        • 10.4.2.6 View Details About the Data Link Job After It Is Run
        • 10.4.2.7 View the Table Resulting from the Data Link Job
    • 10.5 Feeding Data
      • 10.5.1 Creating a Notification-Based Live Table Feed
      • 10.5.2 Creating a Notification-Based Live Table Feed using Amazon Simple Storage Service (S3)
      • 10.5.3 Creating a Notification-Based Live Table Feed using Microsoft Azure
  • 11 The Catalog Page
    • 11.1 About the Catalog Page
    • 11.2 Sorting and Filtering Entities
    • 11.3 Searching for Entities
    • 11.4 Viewing Entity Details
  • 12 The Data Transforms Page
    • 12.1 Accessing the Data Transforms Tool
    • 12.2 Data Transforms Notes
    • 12.3 Creating and Running a Data Load
      • 12.3.1 Creating a Data Load
      • 12.3.2 Running a Data Load
    • 12.4 Working with Connections
      • 12.4.1 List of Supported Connection Types
        • 12.4.1.1 Creating Custom Connectors
        • 12.4.1.2 Creating a Data Transforms Connection for Remote Data Load
        • 12.4.1.3 Creating an Oracle Financials Cloud Connection
        • 12.4.1.4 Creating and Using an Oracle NetSuite Connection
        • 12.4.1.5 Creating an Oracle Object Storage Connection
        • 12.4.1.6 Creating a REST Server Connection
    • 12.5 Working with Data Entities
    • 12.6 Working with Projects
    • 12.7 Creating Data Flows
      • 12.7.1 About Data Flow Editor
        • 12.7.1.1 Oracle Database Functions
      • 12.7.2 Create a New Data Flow
        • 12.7.2.1 Add Components
          • 12.7.2.1.1 Component Properties
          • 12.7.2.1.2 Map Data Columns
        • 12.7.2.2 Create Data Entities within the Data Flow editor
        • 12.7.2.3 Validate and Execute a Data Flow
    • 12.8 Introduction to Workflows
      • 12.8.1 Create a New Workflow
    • 12.9 Scheduling Data Flows or Workflows
    • 12.10 Viewing Status of Data Loads, Data Flows, and Workflows
    • 12.11 Managing Jobs
  • 13 The Data Insights Page
    • 13.1 About Insights
    • 13.2 Generate Insights and View Reports
  • 14 The Data Analysis Tool
    • 14.1 Searching and obtaining information about Analytic Views
    • 14.2 Creating Analytic Views
    • 14.3 Using Calculation Templates
      • 14.3.1 Cumulative Aggregates
      • 14.3.2 Prior and Future Period
      • 14.3.3 Period to Date
      • 14.3.4 Parallel Period
      • 14.3.5 Moving Aggregates
      • 14.3.6 Share
      • 14.3.7 Rank
    • 14.4 Analyzing data
    • 14.5 Oracle Autonomous Database Add-in for Excel
      • 14.5.1 Install the Oracle Autonomous Database add-in on Mac
      • 14.5.2 Install the Oracle Autonomous Database add-in on Windows
      • 14.5.3 Uninstall the Oracle Autonomous Database add-in
      • 14.5.4 Using Oracle Autonomous Database Add-in for Excel
      • 14.5.5 Run native SQL queries in an Excel worksheet
      • 14.5.6 Query an Analytic View in an Excel worksheet
      • 14.5.7 FAQs for Troubleshooting errors with Excel Add-in
    • 14.6 Oracle Autonomous Database add-on for Google Sheets
      • 14.6.1 Install the Oracle Autonomous Database add-on for Google Sheets
      • 14.6.2 Import oracleGoogleAddin files to Google Apps Script manually
      • 14.6.3 Upload oracleGoogleAddin files to Google Apps Script using Clasp
      • 14.6.4 Deploy the Google script as a web app
      • 14.6.5 Create Connections with Google Sheets
      • 14.6.6 Generate Client ID and Client Secret using SQL Command
      • 14.6.7 Generate Client ID and Client Secret using UI
      • 14.6.8 Authorize Google Sheets to use Autonomous Database
      • 14.6.9 Query an Analytic View in Google Sheets
      • 14.6.10 Run SQL Queries
      • 14.6.11 Clear query results
      • 14.6.12 Share or Publish
• Part IV Administration
  • 15 The APEX Workspaces Page
    • 15.1 Create a Workspace
  • 16 The Database Users Page
    • 16.1 About Create/Edit User
    • 16.2 About REST Enable User
    • 16.3 About Delete User
  • 17 The Data Pump Page
    • 17.1 Importing Data using Oracle Data Pump
      • 17.1.1 Requirements
      • 17.1.2 Importing Data
• A Supported SQL*Plus and SQLcl Commands
  • A.1 Supported SQL*Plus Commands
  • A.2 Supported SQLcl Commands
    • A.2.1 SODA Commands