27 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.