Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Product Accessibility
  • Related Documents
  • Conventions
  • Third-Party License Information
• 1 Changes in This Release
• 2 About Oracle Database Actions
  • Accessing Database Actions
    • Enabling User Access to Database Actions
  • About the Database Actions User Interface
    • Using the Omnisearch Bar
  • The Home Page - Launchpad
  • Enabling Detailed Request Error Messages for a Specific Schema
• Part I Development
  • 3 The SQL and Data Modeler Pages
    • The Overview Page
    • The SQL Page
      • Object Navigator and Files
      • Executing SQL Statements in the Code Editor
        • About Session State in Database Actions
        • Keyboard Shortcuts
        • Support for Multilingual Engine
      • Viewing the SQL Output
        • Using the Explain Plan Diagram
      • Loading Data
        • Loading Data from a Local File to a New Table
        • Loading Data from a Local File to an Existing Table
        • Loading Data from Multiple Local Files into Mutiple Tables
        • Format Specifications for JSON and XML Files
          • JSON 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
        • Importing a Resource Module
        • Editing a Resource Module
        • Deleting a Resource Module
        • Publishing/Unpublishing a Resource Module
        • Exporting a Resource Module
        • Viewing the Module in OpenAPI View
      • 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
        • Viewing Resource Handler Details and Managing Parameters
          • Creating a Parameter
          • Editing a Parameter
          • Deleting a Parameter
          • Implicit Parameters
        • Using Pre-Authenticated Requests to Access ORDS RESTful Services
          • Creating a Pre-Authenticated Request
          • Viewing a Pre-Authenticated Request
          • Revoking a Pre-Authenticated Request
      • Example: Inserting a Record using a POST Handler
    • 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
        • Exporting an OAuth Client
        • Managing Secrets
      • Examples
        • Creating an OAuth Client Using the Client Credentials Grant Type
        • Creating an OAuth Client Using the Auth Code Grant Type
  • 5 The JSON Page
    • About the JSON User Interface
    • Managing JSON Collections
      • Creating a Collection
      • About Adding or Editing a JSON Document
        • About Database Differences in JSON Documents
    • About Querying Documents in a Collection
      • Using the In-Context Autocomplete Feature in the JSON Editor
    • Creating Indexes for JSON Collections
    • Creating Relational Views of JSON Documents
    • Viewing the JSON Data Guide Diagram for a Collection
  • 6 The Charts and Dashboards Page
    • Overview
    • Creating or Editing a Chart
    • Example: Creating and Editing a Chart
    • Creating or Editing a Dashboard
  • 7 The Scheduling Pages
    • Overview
    • Jobs
      • Summary
      • Running
      • History
      • Forecast
      • History (Gantt Chart)
      • Notifications
      • Create or Edit Job
    • Chains
      • Create or Edit Chain
      • Add or Edit Step
      • Add or Edit Rule
    • Programs
      • Create or Edit Program
    • Schedules
      • Create or Edit Schedule
    • Objects
      • Create Job Class
      • Create File Watcher
      • Create Window
      • Create Window Group
  • 8 The Liquibase Page
    • Generate a Deployment
    • About the Liquibase User Interface
• Part II Monitoring
  • 9 The Monitoring Pages
    • 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 Dashboard Overview
      • Database Dashboard Activity
    • The AWR Page
• Part III Data Tools
  • 10 The Data Studio Overview Page
  • 11 Python Data Studio API for Oracle Autonomous Database
    • Working with Python Data Studio API for Autonomous Database
      • Ingest Functions
      • Analytic View Functions
      • Insight Functions
      • Miscellaneous functions
      • Data Share Functions
        • Recipient Data Share Functions
        • Provider Data Share Functions
      • Catalog Functions
  • 12 The Data Load Page
    • Data Studio Settings
    • Managing Connections
      • Register Data Catalog
      • Create Credentials
      • Create Oracle Cloud Infrastructure Native Credentials
      • Create Amazon Web Services (AWS) Credentials
      • Manage Resource Principal with DBMS_CLOUD
    • Loading Data
      • Use OCI Language Service Capabilities in Data Studio
        • Overview of Sentiment Analysis, Key Phrase Extraction and Language Detection
        • Parameters to Analyze Data
        • Perform Sentiment Analysis
          • Output Data Generated from OCI Sentiment Analysis
        • Perform Key Phrase Extraction
          • Output Data Generated from OCI Key Phrase Extraction
        • Perform Language Detection
          • Output Data Generated from OCI Language Detection
        • Perform Text Translation
          • Output Data Generated from OCI Text Translation
      • Use OCI Document Understanding to extract Tables from Images
        • Overview of Table Extraction
        • Perform Table Extraction from Image
      • Use GeoJSON in Data Load
        • Add Spatial Expression for GeoJSON columns
        • Parameters for Spatial Data Analysis
        • Perform Spatial Analysis
        • Output Data Generated from Spatial Analysis
      • Loading Data From Local Files
      • Loading Data from Other Databases
        • Load Data from Oracle and Non-Oracle Databases using Database Links
      • Loading Data from Cloud Storage
        • Manage Cloud Storage Links for Data Load Jobs
        • Prepare the Data Load Job
        • Add Files or Folders for the Data Load Job
        • Enter Details for the Data Load Job
        • Run the Data Load Job
        • View Details About the Data Load Job After It Is Run
        • View the Table Resulting from the Data Load Job
      • Load Apache Iceberg Tables
      • Loading Data from File System
        • Create Directories in Database Actions
      • Loading Data from AI Source
      • Loading Data from Share
      • Create Live Feed from Data Load
    • Linking Data
      • Linking to Other Databases
      • Linking to Objects in Cloud Storage
        • Manage Cloud Storage Links for Data Link Jobs
        • Prepare the Data Link Job
        • Add Files or Folders for the Data Link Job
        • Enter Details for the Data Link Job
        • Run the Data Link Job
        • View Details About the Data Link Job After It Is Run
        • View the Table Resulting from the Data Link Job
      • Linking to File System
      • Linking to Share
      • Linking to Data Catalog
    • Feeding Data
      • Creating a Notification-Based Live Table Feed
      • Creating a Notification-Based Live Table Feed using Amazon Simple Storage Service (S3)
      • Creating a Notification-Based Live Table Feed using Microsoft Azure
      • Send Email using Live Feed Tool
    • DBMS_LIVE_FEED Package Reference
      • Summary of DBMS_LIVE_FEED Subprograms
  • 13 The Catalog Tool
    • About the Catalog Page
    • Browse and Search Catalogs
    • Sorting and Filtering Entities
    • Filter Entities
    • Display Entity Search
    • Catalog Settings
    • Manage Catalogs
      • Inline Data Load of Delta Share from the Catalog Tool
      • Query Remote Catalogs and Databases
        • Conceptual Diagram of Querying Remote Catalogs
        • Concepts related to querying remote catalogs and databases
        • About Querying Remote Catalogs and Databases
        • Examples: List the Mounted Catalogs
        • Examples: List the Tables in a Catalog, Including Their Owning Schemas
        • Examples: Query Data from a Table in a Catalog
        • Examples: Query a Table from a Delta Share and Analyze the View
    • Viewing Entity Details
      • Autonomous Database Entity Details
    • Registering Cloud Links to access data
    • Export Data to Cloud
    • Gathering Statistics for Tables
    • Editing Tables
      • 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
  • 14 The Data Transforms Page
    • Access Oracle Data Transforms From Data Studio
    • Data Transforms Notes
    • Work with Connections
      • Supported Connection Types
      • Create Custom Connectors
      • Create a Data Transforms Connection for Remote Data Load
      • Create an Apache Iceberg Connection
      • Create a Delta Share Connection
      • Create an Oracle Business Intelligence Cloud Connector Connection
      • Create and use an Oracle Cloud Infrastructure Generative AI Connection
      • Create an Oracle Enterprise Resource Planning Cloud Connection
      • Create an Oracle Financials Cloud Connection
      • Create and Use an Oracle NetSuite Connection
      • Create an Oracle Object Storage Connection
      • Create a REST Server Connection
    • Create and Run Data Loads
      • Create a Data Load
      • Run a Data Load
    • Work with Data Entities
      • Import Data Entities
      • Create Data Entities
      • Create Data Entities within the Data Flow editor
      • View Statistics of Data Entities
    • Work with Projects
    • About Data Flows
      • Create a Data Flow
      • About Data Flow Editor
      • Supported Database Functions
      • Add Components
      • Use Text Embedding Vector in a Data Flow
      • Component Properties
      • Map Data Columns
      • Validate and Execute a Data Flow
    • Schedule Data Flows or Workflows
    • Monitor Status of Data Loads, Data Flows, and Workflows
    • Introduction to Workflows
      • Create a New Workflow
        • Define a Data Studio Data Load in a Work Flow
    • Create and Use Variables
      • Create a Variable
      • Use Variables in a Data Flow
      • Use Variables in a Workflow
    • Use Machine Learning (ML) Models
      • Create an ML Model Data Entity in the Data Flow editor
      • ML Model Data Entity Properties
      • Use ML Model in a Data Flow
    • Create and Manage Jobs
    • Export and Import Objects
      • Export Objects
      • Import Objects
    • Reference
      • Enable Access to Private Data Sources from Autonomous Database
      • Troubleshoot Mismatch with Server Cert DN Error
      • Increase the Memory of ODI Agent
  • 15 The Data Insights Page
    • About Insights
    • Generate Insights and View Reports
  • 16 The Data Analysis Tool
    • Searching and obtaining information about Analytic Views
    • Creating Analytic Views
    • Working with Analyses
    • Viewing Analyses
    • Workflow to build Analyses
    • Creating Analyses
      • Saving Analyses
    • Creating Reports
      • Working with Reports
      • Creating Reports on a Query
      • Creating Reports on an Analytic View
    • Run Natural Language Query in the Data Analysis Tool
      • Generate SQL Queries From Natural Language on Analytic Views
      • Generate SQL Queries from Natural Language on Tables
    • Generate Natural Language explanation from SQL Query using AI Explain
    • Vector Search in the Data Analysis Tool
    • Format Numeric Columns in the Data Analysis Tool
    • Using Calculation Templates
      • Cumulative Aggregates
      • Prior and Future Period
      • Period to Date
      • Parallel Period
      • Moving Aggregates
      • Share
      • Rank
    • Oracle Autonomous Database for Excel
      • Install the add-in from Microsoft AppSource
      • Install the add-in from Database Actions
        • Install the add-in on Mac
        • Install the add-in on Windows
      • Uninstall the add-in
      • Access the Spreadsheet Add-in by OCI IAM Domains
      • Using Oracle Autonomous Database for Excel
      • Connection management
        • Import a Connection
        • Add a connection
        • Share a connection
      • Log Settings
      • Run Direct SQL queries in an Excel worksheet
      • Read and Access Data Using Table Hyperlinks in Excel Sheet
      • Reporting and Analysis in Excel
      • Query an Analytic View in an Excel worksheet
      • Data Analysis in Excel Sheet
      • Natural Language in Excel Sheet
      • FAQs for Troubleshooting errors with Excel Add-in
      • Oracle Autonomous Database for Excel Privacy Policy Details
    • Oracle Autonomous Database for Google Sheets
      • Install and setup the add-on for Google Sheets
        • Upload oracleGoogleAddin files to Google Apps Script using Clasp
        • Deploy the Google script as a web app
      • Download Connection File
      • Connecting to Autonomous Database
      • Generate Client ID and Client Secret using UI
      • Authorize Google Sheets to use Autonomous Database
      • Natural Language in Google Sheets
      • Data Analysis in Google Sheets
      • Run Direct SQL Queries
      • Reporting and Analysis in Google Sheets
      • Clear Sheet
      • Delete all sheets
      • About Oracle Autonomous Database menu
      • Share or Publish
      • Oracle Autonomous Database for Google Sheets Privacy Policy Details
      • Oracle Autonomous Database for Google Sheets Support
  • 17 The Data Marketplace Tool
    • Access Data Marketplace Tool
    • Publish Listings to Marketplace
    • Consume Dataset
    • DBMS_DATAMART Package Reference
      • Summary of DBMS_DATAMART Subprograms
  • 18 The Table AI Assist Tool
    • Prepare Data Using Table AI Assist Tool
      • Add a Column
      • Replace a Column
      • Remove a Column
      • Rename a Column
      • View Statistical Details about the Table you Load after you Create a Recipe
    • View Table Entity Details
    • Conversational AI for the Table AI Assist Tool
  • 19 The Jobs Feature
    • How to Access the Jobs Feature?
    • Conceptual Diagram of the Jobs Feature
    • Create a Job
    • Manage and Monitor the Job
    • DBMS_DATA_TOOLS_JOBS Package Reference
      • Summary of DBMS_DATA_TOOLS_JOB Subprograms
  • 20 The Data Share Tool
    • Overview of the Data Share Tool
    • Access and Enable the Data Share Tool
    • Provide Share
      • Provide Share Overview
      • Provide Versioned Share
      • Provide Live Share
      • View Share Entity Details
      • Create Share Recipient
      • View Share Recipient Entity Details
    • Consume Share
      • Consume Share Overview
      • Consume Versioned Share
      • Consume Live Share
      • View Share Provider Entity Details
    • Data Share Limitations on Autonomous Database
    • Troubleshooting Errors with the Data Share Tool
    • FAQs on the Data Share Tool
• Part IV Administration
  • 21 The Database Users Page
    • Creating or Editing a User
    • Enabling REST
    • Deleting a User
  • 22 The APEX Workspaces Page
    • Create a Workspace
  • 23 The Data Pump Page
    • Importing Data using Oracle Data Pump
      • Requirements
      • Importing Data
• A Supported SQL*Plus and SQLcl Commands in SQL Worksheet
  • Supported SQL*Plus Commands
  • Supported SQLcl Commands
    • SODA Commands