Table of Contents

• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Diversity and Inclusion
  • Related Documents
  • Conventions
• 1 Get Started Using Autonomous JSON Database
  • About Autonomous JSON Database
  • Work with JSON Documents in Autonomous Database
  • Typical Workflow for Developing Applications with Autonomous JSON Database
  • Upgrade Autonomous JSON Database to Autonomous Transaction Processing
• 2 Create an Autonomous JSON Database
  • Provision an Autonomous JSON Database Instance
• 3 Use Oracle Database Actions with JSON Collections
  • About Database Actions (SQL Developer Web)
  • Use Oracle Database Actions with SODA
  • Use Oracle Database Actions with SQL over SODA Collections
• 4 Develop RESTful Services
  • About Oracle REST Data Services in Autonomous Database
  • Access RESTful Services and SODA for REST
  • Use SODA for REST with Autonomous Database
    • Overview of Using SODA for REST
    • Load Purchase-Order Sample Data Using SODA for REST
    • Use SODA for REST with OAuth Client Credentials
• 5 Build an Application
  • The Basics of Building an Application
  • Build a Java Application
    • Configure Your Java Development System
      • Set JVM Networking Properties
    • Code Database Connections and SQL Statements
  • Build a Node.js Application
    • Configure Your Node.js Development System
    • Code Database Connections and SQL Statements
  • Build a Python Application
    • Configure Your Python Development System
    • Code Database Connections and SQL Statements
• 6 Load JSON
  • About Loading JSON Documents
  • Load a JSON File of Line-Delimited Documents into a Collection
  • Load an Array of JSON Documents into a Collection
  • Create Credentials and Copy JSON Data into an Existing Table
  • Monitor and Troubleshoot COPY_COLLECTION Loads
  • Import SODA Collection Data Using Oracle Data Pump Version 19.6 or Later
  • Textual JSON Objects That Represent Extended Scalar Values
• 7 Oracle Tools for Database Access
  • Connect with Built-In Oracle Database Actions
    • Access Database Actions as ADMIN
    • Provide Database Actions Access to Database Users
  • Connect Oracle SQL Developer with a Wallet (mTLS)
  • Connect Oracle SQLcl Cloud with a Wallet (mTLS)
  • Connect SQL*Plus with a Wallet (mTLS)
• 8 Oracle Extensions for IDEs
  • Use Oracle Cloud Infrastructure Toolkit for Eclipse
  • Use Oracle Developer Tools for Visual Studio
  • Use Oracle Developer Tools for VS Code
• 9 Code for High Performance
  • Connect for High Performance
  • Code for High Performance
  • Tools for Monitoring and Tuning Performance
• A Autonomous JSON Database for Experienced Oracle Database Users
  • About Autonomous Database for Experienced Oracle Database Users
    • Transaction Processing and JSON Database Workloads with Autonomous Database
  • Autonomous Database Views
    • Track Table and Partition Scan Access with Autonomous Database Views
      • GV$TABLE_ACCESS_STATS and V$TABLE_ACCESS_STATS Views
      • ALL_TABLE_ACCESS_STATS and DBA_TABLE_ACCESS_STATS Views
      • USER_TABLE_ACCESS_STATS View
    • Track Oracle Cloud Infrastructure Resources, Cost and Usage Reports with Autonomous Database Views
      • Prerequisite Steps to Use OCI Resource Views
      • OCI_AUTONOMOUS_DATABASES View
      • OCI_BUDGET_ALERT_RULES View
      • OCI_BUDGET_SUMMARY View
      • OCI_COST_DATA View
      • OCI_OBJECTSTORAGE_BUCKETS View
      • OCI_USAGE_DATA View
  • Autonomous Database – Oracle Database Features
  • Always Free Autonomous Database – Oracle Database 21c
    • Always Free Autonomous Database Oracle Database 21c Features
    • Always Free Autonomous Database Oracle Database 21c Notes
  • Autonomous Database RMAN Recovery Catalog
    • Use Autonomous Database as an RMAN Recovery Catalog
  • SODA Notes
  • Notes for Users Migrating from Other Oracle Databases
    • Initialization Parameters
      • SESSION_EXIT_ON_PACKAGE_STATE_ERROR
      • SYSDATE_AT_DBTIMEZONE Select a Time Zone for SYSDATE on Autonomous Database
    • SQL Commands
    • Data Types
    • PL/SQL Package Notes for Autonomous Database
    • Oracle XML DB
    • Oracle Text
    • Oracle Flashback
    • Oracle Database Real Application Security
  • Oracle LogMiner
  • Choose a Character Set for Autonomous Database
    • Notes for Character Set Selection
  • Database Features Unavailable in Autonomous Database
• B SODA Collection Metadata on Autonomous Database
  • SODA Default Collection Metadata on Autonomous Database
  • SODA Customized Collection Metadata on Autonomous Database