Select AI enhancements

Select AI includes the following new features.

• Select AI automatically detects relevant tables and send metadata only for those specific tables, relevant to the query, in Oracle Database 23ai. You can achieve this by specifying object_list_mode as automated.

  See "Automatically Detect Relevant Table Metadata" in Example: Improve SQL Query Generation.

• Select AI enables you to restrict table access by considering only the tables listed in the AI profile attributes for SQL generation. You can achieve this by specifying enforce_object_list to true.

  See Example: Restrict Table Access in AI Profile.

• Select AI enables you to specify case sensitivity such that the LLM produces case-insensitive responses from the database and LLM. You can achieve this by specifying case_sensitive_values to false.

  See Example: Specify Case Sensitivity for Columns.

• Administrators can control data access such that actual schema tables are not sent to the LLM using Select AI.

  See ENABLE_DATA_ACCESS Procedure, DISABLE_DATA_ACCESS Procedure, and Example: Enable or Disable Data Access.