Develop

Describes developer tasks and procedures on Autonomous AI Database.

• Create Applications with Oracle APEX in Autonomous AI Database
  You can create applications with Oracle APEX on Autonomous AI Database.
• Using JSON Documents with Autonomous AI Database
  Autonomous AI Database has full support for data represented as JSON documents. In Autonomous AI Databases, JSON documents can coexist with relational data.
• Developing RESTful Services in Autonomous AI Database
  You can develop and deploy RESTful Services with native Oracle REST Data Services (ORDS) support on Autonomous AI Databases. Simple Oracle Document Access (SODA) for REST lets you use a database as a simple JSON document store.
• Using Oracle Database API for MongoDB
  Oracle Database API for MongoDB makes it possible to connect to Oracle Autonomous AI Database using MongoDB language drivers and tools.
• Send Email and Notifications on Autonomous AI Database
  There are a number of options for sending email on Autonomous AI Database. You can also send notifications to a Slack channel, to MSTeams, or to an OCI Notifications topic.
• User Defined Notification Handler for Scheduler Jobs
  Database Scheduler provides an email notification mechanism to track the status of periodically running or automated jobs. In addition to this, the Database Scheduler also supports user-defined PL/SQL Scheduler job notification handler procedure.
• Oracle Extensions for IDEs
  Oracle extensions let developers connect to, browse, and manage Autonomous AI Databases directly from common IDEs.
• Use Oracle Java on Autonomous AI Database
  Autonomous AI Database supports Oracle JVM. Oracle JVM is a standard, Java-compatible environment that runs any pure Java application.
• Test Workloads with Oracle Real Application Testing
  Oracle Real Application Testing is an extremely cost-effective and easy-to-use proactive performance management solution that enables you to fully assess the outcome of a system change in test or production.
• Manage and Store Files in a Cloud Code Repository with Autonomous AI Database
  Autonomous AI Database provides routines to manage and store files in Cloud Code (Git) Repositories. The supported Cloud Code Repositories are: GitHub, AWS CodeCommit, and Azure Repos.
• Invoke User Defined Functions
  You can invoke external functions such as OCI, AWS Lambda, Google Cloud Run functions and Azure remote functions in your Autonomous AI Database as SQL functions.
• Make External Calls Using a Customer-Managed Wallet
  When your Autonomous AI Database instance is on a private endpoint you can use a customer-managed wallet with procedures in UTL_HTTP, DBMS_LDAP, UTL_SMTP, or UTL_TCP. You can also use a customer-managed wallet when the scheduler sends SMTP email notifications for various events related to scheduler jobs.
• Use Cloud Tables to Store Logging and Diagnostic Information
  You can create Cloud Tables where table data resides on Oracle managed Cloud Storage and the table data does not consume database storage.