DBMS_CLOUD_AI
The DBMS_CLOUD_AI package with Select AI facilitates and configures the translation of natural language prompts to generate, run, and explain SQL statements. It also enables retrieval-augmented generation and natural language-based interactions, including chat with LLMs.
DBMS_CLOUD_AI Overview
Describes the use of the DBMS_CLOUD_AI package.
Use the DBMS_CLOUD_AI package to create AI profiles and configure them for access to a Large Language Model (LLM). Set the AI profile in the current database user session to perform tasks such as generating, running, and explaining SQL.
Summary of DBMS_CLOUD_AI Subprograms
This section covers the DBMS_CLOUD_AI subprograms.
| Subprogram | Description |
|---|---|
| CREATE_PROFILE Procedure | This procedure creates a new AI profile for translating natural language prompts to SQL statements. |
| Profile Attributes | Provides AI profile attributes that you can configure. |
| CLEAR_PROFILE Procedure | This procedure clears an active AI profile in the current session. |
| DISABLE_PROFILE Procedure | This procedure disables an AI profile in the current database. |
| DROP_PROFILE Procedure | This procedure drops an existing AI profile. |
| ENABLE_PROFILE | This procedure enables an AI profile to use in the current database. |
| GENERATE Function | This function enables you to use Select AI in a stateless manner with your existing profile. |
| GENERATE_SYNTHETIC_DATA Function | This function generates synthetic data. |
| GET_PROFILE Function | This function returns the profile name used in the current session. |
| SET_ATTRIBUTE Procedure | This procedure sets AI profile attributes. |
| SET_ATTRIBUTES Procedure | This procedure enables you to set one or more AI profile attributes by accepting attribute name and value pairs in JSON format. |
| SET_PROFILE Procedure | This procedure sets AI profile for the current database. |
| ENABLE_DATA_ACCESS Procedure | Use this procedure to enable sending data to your LLM. |
| DISABLE_DATA_ACCESS Procedure | Use this procedure to disable sending data to your LLM. |
| FEEDBACK Procedure | Use this procedure to potentially improve query generation accuracy by providing a feedback to Select AI. |
| Vector Index FEEDBACK | This is a default vector index created when you first use feedback. |
| CREATE_CONVERSATION Procedure | This procedure helps you to create a conversation. |
| CREATE_CONVERSATION Function | This function helps you to create a conversation and use the conversation ID in other procedures. |
| CREATE_CONVERSATION Attributes | Use the conversation attributes to customize your conversations. |
| UPDATE_CONVERSATION Procedure | This procedure updates an existing procedure with user-specified parameters. |
| SET_CONVERSATION_ID Procedure | This procedure sets conversation support in the current session. |
| GET_CONVERSATION_ID Function | This procedure helps you to get the conversation_id parameter. |
| CLEAR_CONVERSATION_ID Function | This procedure helps you to clear any conversation_id set in the current session. |
| DELETE_CONVERSATION_PROMPT Procedure | This procedure deletes a particular prompt. |
| DROP_CONVERSATION Procedure | This procedure deletes an entire conversation and its metadata. |
| SUMMARIZE Function | This function summarizes your content based on the parameters. |
| SUMMARIZE Parameters | Use the summarize attributes to customize summary generation. |
| TRANSLATE Function | Use the Translate function to convert the entered text into the target language. |
| CREATE_VECTOR_INDEX Procedure | This procedure creates a vector index in the specified vector database, and populates it with data from an object store using an asynchronous scheduler job. |
| DROP_VECTOR_INDEX Procedure | This procedure removes a vector store index. It normally removes the vector store index object and deletes the vector database. |
| DISABLE_VECTOR_INDEX Procedure | This procedure disables a vector index object in the current database. When disabled, an AI profile cannot use the vector index, and the system does not load data into the vector store. |
| ENABLE_VECTOR_INDEX Procedure | This procedure enables or activates a previously disabled vector index object. |
| UPDATE_VECTOR_INDEX Procedure | This procedure updates an existing vector store index with a specified value of the vector index attribute. |
| Vector Index Attributes | Provides vector index profile attributes that you can configure. |