Build Natural Language-Powered Apps with Select AI
summary
Autonomous Database adds a new SQL keyword that lets natural language questions run as queries, returning real SQL and results (example: "top 10 streamed movies" over joined movies and streaming tables), packages query output as JSON, and calls models via an AI profile that can target GPT‑3.5, Oracle Gen AI, Cohere or Llama. Demo apps built with APEX show iterative filtering and personalized email generation (prompted with query results) using select AI and the callable procedure DBMS_CLOUD_AI.GENERATE with normal DB security.
AI-written summary · about
chapters (9)
- 0:00Intro to natural language apps
- 1:58Select AI and private data
- 3:24Building apps with NL queries
- 7:02Extending SQL with Select AI
- 9:33Pluggable AI models
- 12:26Use cases beyond queries
- 14:31SQL-powered retrieval augmented generation
- 16:57Demo: email promotions
- 20:54Summary & resources
related talks
47mHow to query data using natural language - intro to AI features in Oracle 23ai
14mMulticloud Analytics Made Simple
14mAccelerate Scalable, Secure Apps with APEX and GenAI
17mBuild GenAI Apps with Oracle Database 23ai
21mBringing GraphQL Natively To Relational Databases With AI
19mHow to use generative AI to deliver self-service data products
46mPower the next generation of AI apps with databases at scale anywhere
18m3 Oracle AI Use Cases