| Example program | Description | |------------------------------------------------------|-----------------------------------------------------------------------------------| | [INSERT INTO ... BY NAME](./insert_into_by_name.sql) | Demonstrate how to use Oracle AI Database 23.26.2 RU INSERT INTO ... BY NAME syntax. | | [JSON_TRANSFORM function](./json_transform.sql) | Examples using `JSON_TRANSFORM` to modify JSON data. | | [Select AI](./select_ai.sql) | Get started with Select AI on Autonomous Database. | | [Similarity Search](./similarity_search.sql) | Simple use of Similarity Search with vectors (AI Vector Search) |
What this sample demonstrates
Vector Search
Store embeddings and search records by semantic similarity.
Use when users search by meaning or AI answers need grounded records.
JSON
Document-shaped data and SQL/JSON querying inside Oracle AI Database.
Use when records need flexible structure without leaving SQL, indexes, constraints, and transactions.