Search notes:

Oracle: SELECT AI

SELECT AI [action]  …;

Action

action is one of

`RUNSQL`	Generated and execute an SQL statement that hopefully does what the prompt requests. This is the default action if `action` is omitted.
`SHOWSQL`	Shows the SQL statement rather than running it.
`EXPLAINSQL`	Explains the generated statement in natural language (not `explain plan`).
`NARRATE`	Send the result of the executed SQL statement back to the LLM and let it describe it.
`CHAT`	Let the LLM create a response from the prompt without using SQL.

See also the action parameter of dbms_cloud_ai.generate.

Misc

An AI profile needs to be set with dbms_cloud_ai.set_profile, otherwise, select ai … throws ORA-00923: FROM keyword not found where expected

Single quotes in the prompt following select ai need to be quoted as in ordinary strings:

select ai Who didn''t order anything last month?

The AI keyword is understood by the select statement only.

The text after select ai is case sensitive.

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1788393822, '216.73.217.21', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/SQL/select/ai/index(70): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78