17 Select AI PL/SQL Package
The DBMS_CLOUD_AI package is available to support Select AI.
| Subprogram | Description |
|---|---|
| CREATE_PROFILE Procedure | This procedure creates a new AI profile for translating natural language prompts to SQL statements. |
| 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. |
| 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. |
| 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. |
| 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. |