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
  • 2.1 Accessing Database Actions
    • 2.1.1 Enabling User Access to Database Actions
  • 2.2 About the Database Actions User Interface
    • 2.2.1 Using the Omnisearch Bar
  • 2.3 The Home Page - Launchpad
  • 2.4 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.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.3.4 Viewing Resource Handler Details and Managing Parameters
          • 4.6.3.4.1 Creating a Parameter
          • 4.6.3.4.2 Editing a Parameter
          • 4.6.3.4.3 Deleting a Parameter
          • 4.6.3.4.4 Implicit Parameters
        • 4.6.3.5 Using Pre-Authenticated Requests to Access ORDS RESTful Services
          • 4.6.3.5.1 Creating a Pre-Authenticated Request
          • 4.6.3.5.2 Viewing a Pre-Authenticated Request
          • 4.6.3.5.3 Revoking a Pre-Authenticated Request
      • 4.6.4 Example: Inserting a Record using a POST Handler
    • 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.3.4 Exporting an OAuth Client
        • 4.7.3.5 Managing Secrets
      • 4.7.4 Examples
        • 4.7.4.1 Creating an OAuth Client Using the Client Credentials Grant Type
        • 4.7.4.2 Creating an OAuth Client Using the Auth Code Grant Type
  • 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 Vector Database
  • The Vector Database Page
    • Install the Python SDK
    • Use the Vector Database Console
      • Manage Models Using the Vector Database Console
        • Load a Model Using the Vector Database Console
        • Remove a Model Using the Vector Database Console
      • Manage Vector Tables Using the Vector Database Console
        • Create a Vector Table Using the Vector Database Console
        • Drop a Vector Table Using the Vector Database Console
      • Use the Query Playground
        • Perform a Text Search
        • Perform a Vector Search
    • Manage Models
      • Load Your Own ONNX Model
      • List Available Models
      • Describe a Model
      • Drop a Model
    • Manage Vector Tables
      • Describe the Vector Database
      • List Vector Tables
      • Create a Vector Table
      • Describe a Vector Table
      • Drop a Vector Table
      • Update a Vector Table Annotation
    • Manage Data
      • Embed Data
      • Upsert Records
        • Upsert Text
        • Upsert Vectors
      • Load Data Sets
      • List Vectors
      • Delete Vectors
      • List Vector Load Jobs
      • Describe a Bulk Load Job
      • Retrieve Log Output for Bulk Loads
    • Search Data
      • Semantic Search
      • Filter by Metadata
      • Search with Advanced Options
      • Rerank Results
    • Manage Indexes
      • Describe an Index
      • Create an Index
      • Rebuild an Index
      • Drop an Index
      • List Vector Load Jobs
      • Describe an Index Job
      • Retrieve an Index Job Log
    • Manage Vector Database Users
      • Create a New Vector Database User
        • Create a New Vector Database User Using SQL
      • Grant Privileges to an Existing Vector Database User
    • Configure an OAuth Client
• Part III Monitoring
  • 9 The Monitoring Pages
    • 9.1 The Monitoring Overview Page
    • 9.2 The Performance Hub Page
    • 9.3 The Alerts Page
    • 9.4 The Sessions Page
    • 9.5 The Storage Page
    • 9.6 The Parameters Page
    • 9.7 The Database Dashboard Page
      • 9.7.1 Database Dashboard Overview
      • 9.7.2 Database Dashboard Activity
    • 9.8 The AWR Page
• Part IV Administration
  • 10 The Database Users Page
    • 10.1 Creating or Editing a User
    • 10.2 Enabling REST
    • 10.3 Deleting a User
  • 11 The APEX Workspaces Page
    • 11.1 Create a Workspace
  • 12 The Data Pump Page
    • 12.1 Importing Data using Oracle Data Pump
      • 12.1.1 Requirements
      • 12.1.2 Importing Data
• Part V Data Tools
  • 13 The Data Studio Overview Page
  • 14 Python Data Studio API for Oracle Autonomous Database
    • 14.1 Working with Python Data Studio API for Autonomous Database
      • 14.1.1 Ingest Functions
      • 14.1.2 Analytic View Functions
      • 14.1.3 Insight Functions
      • 14.1.4 Miscellaneous functions
      • 14.1.5 Data Share Functions
        • 14.1.5.1 Recipient Data Share Functions
        • 14.1.5.2 Provider Data Share Functions
      • 14.1.6 Catalog Functions
  • 15 The Data Load Page
    • 15.1 Data Studio Settings
      • 15.1.1 Slack Integration with Data Studio
      • 15.1.2 About AI Profiles
        • 15.1.2.1 Create an AI Profile
        • 15.1.2.2 Manage AI Profiles
    • 15.2 Managing Connections
      • 15.2.1 Register Data Catalog
      • 15.2.2 Create Credentials
      • 15.2.3 Create Oracle Cloud Infrastructure Native Credentials
      • 15.2.4 Create Amazon Web Services (AWS) Credentials
      • 15.2.5 Manage Resource Principal with DBMS_CLOUD
    • 15.3 Loading Data
      • 15.3.1 Use OCI Language Service Capabilities in Data Studio
        • 15.3.1.1 Overview of Sentiment Analysis, Key Phrase Extraction and Language Detection
        • 15.3.1.2 Parameters to Analyze Data
        • 15.3.1.3 Perform Sentiment Analysis
          • 15.3.1.3.1 Output Data Generated from OCI Sentiment Analysis
        • 15.3.1.4 Perform Key Phrase Extraction
          • 15.3.1.4.1 Output Data Generated from OCI Key Phrase Extraction
        • 15.3.1.5 Perform Language Detection
          • 15.3.1.5.1 Output Data Generated from OCI Language Detection
        • 15.3.1.6 Perform Text Translation
          • 15.3.1.6.1 Output Data Generated from OCI Text Translation
      • 15.3.2 Use OCI Document Understanding to extract Tables from Images
        • 15.3.2.1 Overview of Table Extraction
        • 15.3.2.2 Perform Table Extraction from Image
      • 15.3.3 Use GeoJSON in Data Load
        • 15.3.3.1 Add Spatial Expression for GeoJSON columns
        • 15.3.3.2 Parameters for Spatial Data Analysis
        • 15.3.3.3 Perform Spatial Analysis
        • 15.3.3.4 Output Data Generated from Spatial Analysis
      • 15.3.4 Loading Data From Local Files
      • 15.3.5 Loading Data from Other Databases
        • 15.3.5.1 Load Data from Oracle and Non-Oracle Databases using Database Links
      • 15.3.6 Loading Data from Cloud Storage
        • 15.3.6.1 Manage Cloud Storage Links for Data Load Jobs
        • 15.3.6.2 Prepare the Data Load Job
        • 15.3.6.3 Add Files or Folders for the Data Load Job
        • 15.3.6.4 Enter Details for the Data Load Job
        • 15.3.6.5 Run the Data Load Job
        • 15.3.6.6 View Details About the Data Load Job After It Is Run
        • 15.3.6.7 View the Table Resulting from the Data Load Job
      • 15.3.7 Load Apache Iceberg Tables
      • 15.3.8 Loading Data from File System
        • 15.3.8.1 Create Directories in Database Actions
      • 15.3.9 Loading Data from AI Source
      • 15.3.10 Loading Data from Share
      • 15.3.11 Create Live Feed from Data Load
    • 15.4 Linking Data
      • 15.4.1 Linking to Other Databases
      • 15.4.2 Linking to Objects in Cloud Storage
        • 15.4.2.1 Manage Cloud Storage Links for Data Link Jobs
        • 15.4.2.2 Prepare the Data Link Job
        • 15.4.2.3 Add Files or Folders for the Data Link Job
        • 15.4.2.4 Enter Details for the Data Link Job
        • 15.4.2.5 Run the Data Link Job
        • 15.4.2.6 View Details About the Data Link Job After It Is Run
        • 15.4.2.7 View the Table Resulting from the Data Link Job
      • 15.4.3 Linking to File System
      • 15.4.4 Linking to Share
      • 15.4.5 Linking to Data Catalog
    • 15.5 Feeding Data
      • 15.5.1 Creating a Notification-Based Live Table Feed
      • 15.5.2 Creating a Notification-Based Live Table Feed using Amazon Simple Storage Service (S3)
      • 15.5.3 Creating a Notification-Based Live Table Feed using Microsoft Azure
      • 15.5.4 Send Email using Live Feed Tool
    • 15.6 DBMS_LIVE_FEED Package Reference
      • 15.6.1 Summary of DBMS_LIVE_FEED Subprograms
  • 16 The Catalog Tool
    • 16.1 About the Catalog Page
    • 16.2 Browse and Search Catalogs
    • 16.3 Sorting and Filtering Entities
    • 16.4 Filter Entities
    • 16.5 Display Entity Search
    • 16.6 Catalog Settings
    • 16.7 Metadata Enrichment
    • 16.8 Manage Catalogs
      • 16.8.1 Manage Catalog Cache
      • 16.8.2 Inline Data Load of Delta Share from the Catalog Tool
      • 16.8.3 Query Remote Catalogs and Databases
        • 16.8.3.1 Conceptual Diagram of Querying Remote Catalogs
        • 16.8.3.2 Concepts related to querying remote catalogs and databases
        • 16.8.3.3 About Querying Remote Catalogs and Databases
        • 16.8.3.4 Examples: List the Mounted Catalogs
        • 16.8.3.5 Examples: List the Tables in a Catalog, Including Their Owning Schemas
        • 16.8.3.6 Examples: Query Data from a Table in a Catalog
        • 16.8.3.7 Examples: Query a Table from a Delta Share and Analyze the View
    • 16.9 Viewing Entity Details
      • 16.9.1 Autonomous Database Entity Details
    • 16.10 Register to Cloud Links for Accessing Data
    • 16.11 Export Data to Cloud
    • 16.12 Gathering Statistics for Tables
    • 16.13 Editing Tables
      • 16.13.1 Columns Pane
      • 16.13.2 Primary Key Pane
      • 16.13.3 Unique Keys Pane
      • 16.13.4 Indexes Pane
      • 16.13.5 Foreign Keys Pane
      • 16.13.6 Table Constraints Pane
      • 16.13.7 Comments Pane
      • 16.13.8 Storage Pane
      • 16.13.9 External Table Properties Pane
      • 16.13.10 Materialized View Pane
      • 16.13.11 DDL Pane
      • 16.13.12 Output Pane
    • 16.14 Manage Catalogs with DBMS_CATALOG
      • 16.14.1 DBMS_CATALOG Package
      • 16.14.2 Summary of DBMS_CATALOG
        • 16.14.2.1 MOUNT_DATA_CATALOG Procedure
        • 16.14.2.2 MOUNT_DB_LINK Procedure
        • 16.14.2.3 MOUNT_ICEBERG Procedure
        • 16.14.2.4 MOUNT_SHARE Procedure
        • 16.14.2.5 MOUNT_SHARES Procedure
        • 16.14.2.6 MOUNT_VIRTUAL_CATALOG Procedure
        • 16.14.2.7 UNMOUNT Procedure
        • 16.14.2.8 GET_CATALOG_PROPERTY Procedure
        • 16.14.2.9 GET_CATALOG_PROPERTY_CLOB Procedure
        • 16.14.2.10 UPDATE_CATALOG_PROPERTY Procedure
        • 16.14.2.11 UPDATE_CATALOG_PROPERTY_CLOB Procedure
        • 16.14.2.12 GET_COLUMN_PROPERTY Function
        • 16.14.2.13 GET_COLUMN_PROPERTY_CLOB Function
        • 16.14.2.14 UPDATE_COLUMN_PROPERTY Procedure
        • 16.14.2.15 UPDATE_COLUMN_PROPERTY_CLOB Procedure
        • 16.14.2.16 GET_SCHEMA_PROPERTY Procedure
        • 16.14.2.17 GET_SCHEMA_PROPERTY_CLOB Procedure
        • 16.14.2.18 UPDATE_SCHEMA_PROPERTY Procedure
        • 16.14.2.19 UPDATE_SCHEMA_PROPERTY_CLOB Procedure
        • 16.14.2.20 GET_TABLE_PROPERTY Procedure
        • 16.14.2.21 GET_TABLE_PROPERTY_CLOB Procedure
        • 16.14.2.22 UPDATE_TABLE_PROPERTY Procedure
        • 16.14.2.23 UPDATE_TABLE_PROPERTY_CLOB Procedure
        • 16.14.2.24 ADD_REQUIRED_CREDENTIAL Procedure
        • 16.14.2.25 REMOVE_REQUIRED_CREDENTIAL Procedure
        • 16.14.2.26 RENAME_REQUIRED_CREDENTIAL Procedure
        • 16.14.2.27 GET_REQUIRED_CREDENTIAL_PROPERTY Procedure
        • 16.14.2.28 UPDATE_REQUIRED_CREDENTIAL_PROPERTY Procedure
        • 16.14.2.29 GET_LOCAL_CREDENTIAL_MAP (Overloaded) Procedure
        • 16.14.2.30 SET_LOCAL_CREDENTIAL Procedure
        • 16.14.2.31 GET_CLOUD_STORAGE_LINK_PROPERTY Function
        • 16.14.2.32 GET_CLOUD_STORAGE_LINK_PROPERTY_CLOB Function
        • 16.14.2.33 UPDATE_CLOUD_STORAGE_LINK_PROPERTY Procedure
        • 16.14.2.34 UPDATE_CLOUD_STORAGE_LINK_PROPERTY_CLOB Procedure
        • 16.14.2.35 CREATE_CLOUD_STORAGE_LINK Procedure
        • 16.14.2.36 DROP_CLOUD_STORAGE_LINK Procedure
        • 16.14.2.37 GET_CLOUD_STORAGE_LINKS Function
        • 16.14.2.38 GET_COLUMNS Function
        • 16.14.2.39 CREATE_EXTERNAL_TABLE Procedure
        • 16.14.2.40 CREATE_SCHEMA Procedure
        • 16.14.2.41 DROP_SCHEMA Procedure
        • 16.14.2.42 GET_OBJECTS Procedure
        • 16.14.2.43 GET_SCHEMAS Procedure
        • 16.14.2.44 GET_TABLES Procedure
        • 16.14.2.45 GET_TABLE Procedure
        • 16.14.2.46 GET_TABLE Function
        • 16.14.2.47 DROP_TABLE Procedure
        • 16.14.2.48 GENERATE_TABLE_SELECT (Overloaded) Procedure
        • 16.14.2.49 OPEN_TABLE_CURSOR Procedure
        • 16.14.2.50 FLUSH_CATALOG_CACHE Procedure
        • 16.14.2.51 PREFILL_CATALOG_CACHE Procedure
        • 16.14.2.52 CREATE_SYNCHRONIZED_SCHEMAS Procedure
        • 16.14.2.53 DROP_SYNCHRONIZED_SCHEMAS Procedure
        • 16.14.2.54 UPDATE_SYNCHRONIZED_SCHEMA_PROPERTY Procedure
        • 16.14.2.55 SYNCHRONIZE_SHARED_CATALOGS Procedure
        • 16.14.2.56 CREATE_SYNCHRONIZED_VIEWS Procedure
        • 16.14.2.57 COPY_TABLE_PROPERTIES Procedure
        • 16.14.2.58 GRANT_TO_RECIPIENT Procedure
        • 16.14.2.59 REVOKE_FROM_RECIPIENT Procedure
        • 16.14.2.60 CLEAR_CATALOG_EVENTS Procedure
        • 16.14.2.61 CREATE_ICEBERG_TABLE Procedure
        • 16.14.2.62 ADD_ICEBERG_SNAPSHOT Procedure
  • 17 The Data Transforms Page
    • 17.1 Access Oracle Data Transforms From Data Studio
    • 17.2 Data Transforms Notes
    • 17.3 Work with Connections
      • 17.3.1 Supported Connection Types
      • 17.3.2 Create Custom Connectors
      • 17.3.3 Create a Data Transforms Connection for Remote Data Load
      • 17.3.4 Create an Apache Iceberg Connection
      • 17.3.5 Create a Delta Share Connection
      • 17.3.6 Create an Oracle Business Intelligence Cloud Connector Connection
      • 17.3.7 Create and use an Oracle Cloud Infrastructure Generative AI Connection
      • 17.3.8 Create an Oracle Enterprise Resource Planning Cloud Connection
      • 17.3.9 Create an Oracle Financials Cloud Connection
      • 17.3.10 Create and Use an Oracle NetSuite Connection
      • 17.3.11 Create an Oracle Object Storage Connection
      • 17.3.12 Create a REST Server Connection
    • 17.4 Create and Run Data Loads
      • 17.4.1 Create a Data Load
      • 17.4.2 Run a Data Load
    • 17.5 Work with Data Entities
      • 17.5.1 Import Data Entities
      • 17.5.2 Create Data Entities
      • 17.5.3 Create Data Entities within the Data Flow editor
      • 17.5.4 View Statistics of Data Entities
    • 17.6 Work with Projects
    • 17.7 About Data Flows
      • 17.7.1 Create a Data Flow
      • 17.7.2 About Data Flow Editor
      • 17.7.3 Supported Database Functions
      • 17.7.4 Add Components
      • 17.7.5 Use Text Embedding Vector in a Data Flow
      • 17.7.6 Component Properties
      • 17.7.7 Map Data Columns
      • 17.7.8 Validate and Execute a Data Flow
    • 17.8 Schedule Data Flows or Workflows
    • 17.9 Monitor Status of Data Loads, Data Flows, and Workflows
    • 17.10 Introduction to Workflows
      • 17.10.1 Create a New Workflow
        • 17.10.1.1 Define a Data Studio Data Load in a Work Flow
    • 17.11 Create and Use Variables
      • 17.11.1 Create a Variable
      • 17.11.2 Use Variables in a Data Flow
      • 17.11.3 Use Variables in a Workflow
    • 17.12 Use Machine Learning (ML) Models
      • 17.12.1 Create an ML Model Data Entity in the Data Flow editor
      • 17.12.2 ML Model Data Entity Properties
      • 17.12.3 Use ML Model in a Data Flow
    • 17.13 Create and Manage Jobs
    • 17.14 Export and Import Objects
      • 17.14.1 Export Objects
      • 17.14.2 Import Objects
    • 17.15 Reference
      • 17.15.1 Enable Access to Private Data Sources from Autonomous Database
      • 17.15.2 Troubleshoot Mismatch with Server Cert DN Error
      • 17.15.3 Increase the Memory of ODI Agent
  • 18 The Data Insights Page
    • 18.1 About Insights
    • 18.2 Generate Insights and View Reports
  • 19 The Data Analysis Tool
    • 19.1 Searching and obtaining information about Analytic Views
    • 19.2 Creating Analytic Views
    • 19.3 Working with Analyses
    • 19.4 Viewing Analyses
    • 19.5 Workflow to build Analyses
    • 19.6 Creating Analyses
      • 19.6.1 Saving Analyses
    • 19.7 Creating Reports
      • 19.7.1 Working with Reports
      • 19.7.2 Creating Reports on a Query
      • 19.7.3 Creating Reports on an Analytic View
    • 19.8 Run Natural Language Query in the Data Analysis Tool
      • 19.8.1 Generate SQL Queries From Natural Language on Analytic Views
      • 19.8.2 Generate SQL Queries from Natural Language on Tables
    • 19.9 Generate Natural Language explanation from SQL Query using AI Explain
    • 19.10 Vector Search in the Data Analysis Tool
    • 19.11 Format Numeric Columns in the Data Analysis Tool
    • 19.12 Using Calculation Templates
      • 19.12.1 Cumulative Aggregates
      • 19.12.2 Prior and Future Period
      • 19.12.3 Period to Date
      • 19.12.4 Parallel Period
      • 19.12.5 Moving Aggregates
      • 19.12.6 Share
      • 19.12.7 Rank
    • 19.13 Use Oracle Database for Spreadsheet Add-ins
      • 19.13.1 About Oracle Database for Spreadsheet Add-ins
        • 19.13.1.1 Privacy Policies and Contact Details
      • 19.13.2 Installation Options for Spreadsheet Add-ins
        • 19.13.2.1 Download Spreadsheet Add-ins from Database Actions
        • 19.13.2.2 Install Add-in for Microsoft Excel from Trusted Catalogs
        • 19.13.2.3 Install Add-in for Excel from Office Store
        • 19.13.2.4 Install Add-on for Google Sheets from Google Workspace Marketplace
      • 19.13.3 Connect to Autonomous AI Database from a Spreadsheet
      • 19.13.4 Manage Connections
      • 19.13.5 Access the Spreadsheet Add-in by OCI IAM Domains
      • 19.13.6 Use Role-Based Access Control for IAM Authentication
        • 19.13.6.1 Configure Role-Based Access Control Manually
        • 19.13.6.2 Set up Role-Based Access Control Automatically using a Script
      • 19.13.7 Using Spreadsheet Add-ins Features
        • 19.13.7.1 UI Options in Spreadsheet Add-ins
        • 19.13.7.2 Run Natural Language Queries
        • 19.13.7.3 Run Direct SQL Queries
        • 19.13.7.4 Perform Data Analysis using Spreadsheet Add-ins
        • 19.13.7.5 Access and Share Data using Table Hyperlinks
      • 19.13.8 Manage Settings
      • 19.13.9 Remove Spreadsheet Add-ins
      • 19.13.10 Troubleshoot Scenarios with Spreadsheet Add-ins
  • 20 The Data Marketplace Tool
    • 20.1 Access Data Marketplace Tool
    • 20.2 Publish Listings to Marketplace
    • 20.3 Consume Dataset
    • 20.4 DBMS_DATAMART Package Reference
      • 20.4.1 Summary of DBMS_DATAMART Subprograms
  • 21 The Table AI Assist Tool
    • 21.1 Prepare Data Using Table AI Assist Tool
      • 21.1.1 Add a Column
      • 21.1.2 Replace a Column
      • 21.1.3 Remove a Column
      • 21.1.4 Rename a Column
      • 21.1.5 View Statistical Details about the Table you Load after you Create a Recipe
    • 21.2 View Table Entity Details
    • 21.3 Conversational AI for the Table AI Assist Tool
  • 22 The Jobs Feature
    • 22.1 How to Access the Jobs Feature?
    • 22.2 Conceptual Diagram of the Jobs Feature
    • 22.3 Create a Job
    • 22.4 Manage and Monitor the Job
    • 22.5 DBMS_DATA_TOOLS_JOBS Package Reference
      • 22.5.1 Summary of DBMS_DATA_TOOLS_JOB Subprograms
  • 23 The Data Share Tool
    • 23.1 Overview of the Data Share Tool
    • 23.2 Access and Enable the Data Share Tool
    • 23.3 Provide Share
      • 23.3.1 Provide Share Overview
      • 23.3.2 Provide Versioned Share
      • 23.3.3 Provide Live Share
      • 23.3.4 View Share Entity Details
      • 23.3.5 Create Share Recipient
      • 23.3.6 View Share Recipient Entity Details
    • 23.4 Consume Share
      • 23.4.1 Consume Share Overview
      • 23.4.2 Consume Versioned Share
      • 23.4.3 Enable File-Level Change Data Feed Access for Versioned Shares
      • 23.4.4 Consume Live Share
      • 23.4.5 View Share Provider Entity Details
      • 23.4.6 Sharing Databricks Tables with Deletion Vectors
    • 23.5 Manage Shares with DBMS_SHARE
    • 23.6 Data Share Limitations on Autonomous AI Database
    • 23.7 Troubleshooting Errors with the Data Share Tool
      • 23.7.1 Live Share Feature Slow Performance
      • 23.7.2 Shared Table Query Attempt Failure
      • 23.7.3 HTTP 403 Unauthorized Due to Remote IP Allowlist
    • 23.8 FAQs on the Data Share Tool
• A Supported SQL*Plus and SQLcl Commands in SQL Worksheet
  • A.1 Supported SQL*Plus Commands
  • A.2 Supported SQLcl Commands
    • A.2.1 SODA Commands