49 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.
49.1 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.
49.2 Summary of DBMS_CLOUD_AI Subprograms
This section covers the DBMS_CLOUD_AI subprograms.
| Subprogram | Description |
|---|---|
|
This procedure creates a new AI profile for translating natural language prompts to SQL statements. |
|
|
Provides AI profile attributes that you can configure. |
|
|
This procedure clears an active AI profile in the current session. |
|
|
This procedure disables an AI profile in the current database. |
|
|
This procedure drops an existing AI profile. |
|
|
This procedure enables an AI profile to use in the current database. |
|
| This function enables you to use Select AI in a stateless manner with your existing profile. | |
|
This function generates synthetic data. |
|
|
This function returns the profile name used in the current session. |
|
|
This procedure sets AI profile attributes. |
|
|
This procedure enables you to set one or more AI profile attributes by accepting attribute name and value pairs in JSON format. |
|
|
This procedure sets AI profile for the current database. |
|
|
Use this procedure to enable sending data to your LLM. |
|
|
Use this procedure to disable sending data to your LLM. |
|
|
Use this procedure to potentially improve query generation accuracy by providing a feedback to Select AI. |
|
|
This is a default vector index created when you first
use |
|
|
This procedure helps you to create a conversation. |
|
|
This function helps you to create a conversation and use the conversation ID in other procedures. |
|
|
Use the conversation attributes to customize your conversations. |
|
|
This procedure updates an existing procedure with user-specified parameters. |
|
|
This procedure sets conversation support in the current session. |
|
|
This procedure helps you to get the
|
|
|
This procedure helps you to clear any
|
|
|
This procedure deletes a particular prompt. |
|
|
This procedure deletes an entire conversation and its metadata. |
|
|
This function summarizes your content based on the parameters. |
|
|
Use the summarize attributes to customize summary generation. |
|
|
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. |
|
|
This procedure removes a vector store index. It normally removes the vector store index object and deletes the vector database. |
|
|
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. |
|
|
This procedure enables or activates a previously disabled vector index object. |
|
|
This procedure updates an existing vector store index with a specified value of the vector index attribute. |
|
|
Provides vector index profile attributes that you can configure. |