By Vinish Kapoor

Oracle Database 26ai Tutorials

Every Oracle AI Database 26ai and 23ai tutorial on vinish.dev: vectors, semantic search, LLMs and RAG in PL/SQL, plus SQL and PL/SQL essentials.

  • 89 tutorials
  • 10 topics
  • 4 learning paths
  • Updated October 2026

Browse by topic

Learning paths

Ordered series you can follow from the first lesson to the last.

Intermediate

Build AI Applications in the Database

From AI concepts and embeddings to vector indexes, hybrid search, RAG, safe NL2SQL, and production deployment.

Start with: AI Concepts Explained for Oracle Developers

All 36 lessons
  1. AI Concepts Explained for Oracle Developers
  2. How to Call Gemini from Oracle Database with a Stored Credential
  3. How to Use the VECTOR Data Type in Oracle AI Database 26ai
  4. How to Measure Vector Distance with VECTOR_DISTANCE in Oracle
  5. How to Load an ONNX Embedding Model into Oracle Database
  6. How to Generate Embeddings in SQL with VECTOR_EMBEDDING
  7. How to Generate Embeddings with Gemini from PL/SQL
  8. How to Choose an Embedding Model: In-Database vs Gemini
  9. How to Create an IVF Vector Index in Oracle
  10. How to Create an HNSW Vector Index in Oracle
  11. How to Build Semantic Search in Oracle Database
  12. How to Search by Keyword with Oracle Text
  13. How to Build Hybrid Search in Oracle Database
  14. How to Chunk Documents for Vector Search in Oracle
  15. How to Search PDF Documents by Meaning in Oracle
  16. How to Call an LLM from PL/SQL with UTL_TO_GENERATE_TEXT
  17. How to Make LLM Calls Reliable in PL/SQL
  18. How to Classify Data with an LLM in Oracle SQL
  19. How to Extract Structured Data from Text with an LLM in Oracle
  20. How to Build RAG with PL/SQL in Oracle Database
  21. How to Test AI Answers with an LLM Grader in Oracle
  22. How to Generate SQL from Natural Language with an LLM in Oracle
  23. How to Run LLM-Generated SQL Safely in Oracle
  24. How to Use Machine Learning on Embeddings in Oracle Database
  25. How to Join Tables by Meaning with Vector Search in Oracle
  26. How to Store Vectors in JSON Documents in Oracle
  27. How to Rank Graph Paths by Meaning with SQL Property Graphs
  28. How to Run a Local LLM with Ollama from Oracle Database
  29. How to Redact Personal Data Before Calling an LLM in Oracle
  30. How to Defend Oracle AI Applications Against Prompt Injection
  31. How to Control What an AI Assistant Can See with Row-Level Security
  32. How to Reduce the Cost of LLM Calls in Oracle
  33. How to Run AI Jobs in the Background with DBMS_SCHEDULER
  34. How to Deploy Oracle AI Applications to Production
  35. How to Install Oracle AI Database 26ai Free on Oracle Linux
  36. How to Install Oracle AI Database 26ai Free on Windows
Beginner

SQL Essentials

Create a table, then query, change, and join data, step by step.

Start with: How to Create a Table in Oracle 23ai

All 15 lessons
  1. How to Create a Table in Oracle 23ai
  2. Understanding Data Types in Oracle Database 23ai
  3. How to Insert Data into a Table in Oracle 23ai
  4. How to Use SELECT Queries in Oracle Database 23ai
  5. How to Use WHERE Clause in Oracle Database 23ai Queries
  6. How to Use ORDER BY in Oracle Database 23ai Queries
  7. How to Use GROUP BY in Oracle Database 23ai
  8. Using UPDATE Statement in Oracle Database 23ai
  9. Using DELETE Statement in Oracle Database 23ai
  10. Using MERGE Statement in Oracle Database 23ai
  11. Oracle SQL INNER JOIN: Complete Guide to Matching Records Between Tables
  12. Oracle SQL Query to Use LEFT OUTER JOIN to Include All Records from Left Table
  13. Oracle SQL Query to Use Full Outer Join for Data Reconciliation
  14. Oracle SQL Query to Use EXPLAIN PLAN for Join Analysis
  15. Synonym in Oracle Database
Beginner

PL/SQL Essentials

Your first block to procedures, packages, triggers, and debugging.

Start with: Hello World Program in Oracle Database 23ai PL/SQL

All 15 lessons
  1. Hello World Program in Oracle Database 23ai PL/SQL
  2. Understanding Variables and Constants in Oracle Database 23ai PL/SQL
  3. How to Use IF Statements in Oracle Database 23ai PL/SQL
  4. How to Use CASE Statement in Oracle Database 23ai PL/SQL
  5. How to Loop in Oracle Database 23ai PL/SQL
  6. How to Use Cursors in Oracle Database 23ai PL/SQL
  7. How to Use Explicit Cursors in PL/SQL (Oracle Database 23ai)
  8. How to Handle Exceptions in Oracle Database 23ai PL/SQL
  9. How to Create Procedures in Oracle Database 23ai PL/SQL
  10. How to Create Functions in Oracle Database 23ai PL/SQL
  11. How to Create Packages in Oracle Database 23ai PL/SQL
  12. How to Use Triggers in Oracle Database 23ai PL/SQL
  13. Using DBMS_OUTPUT to Debug PL/SQL Code
  14. Error Handling with Dbms_utility.format_error_backtrace
  15. Using PL/SQL UTL_FILE to Read and Write Files
Practical

SQL Query Recipes

Analytics patterns you can reuse: running totals, cohorts, churn, gaps and islands.

Start with: Oracle SQL Query to Calculate Business Days Excluding Holidays

All 12 lessons
  1. Oracle SQL Query to Calculate Business Days Excluding Holidays
  2. Oracle SQL Query to Find Overlapping Date Ranges
  3. Oracle SQL Query to Implement Cohort Analysis for Customer Retention
  4. Oracle SQL Query to Identify and Handle Duplicate Records
  5. Oracle SQL Query to Parse and Extract JSON Data with JSON_TABLE
  6. Oracle SQL Query to Calculate Churn Rate and Retention Metrics
  7. Oracle SQL Query to Perform ABC Analysis for Inventory Management
  8. Oracle SQL Query to Calculate Running Totals
  9. Oracle SQL Query to Find Gaps and Islands in Sequential Data
  10. Oracle SQL Query to Use LISTAGG for String Aggregation
  11. How to Convert Oracle Database Tables to JSON Format
  12. Oracle SQL Query to Implement Lead/Lag Analysis for Time Series Data

Latest tutorials

Books & free tools

Go deeper with the books, or try the free tools.

All tutorials by topic

Getting Started & Setup 9

What's new in 26ai and 23ai, installing the database and SQL Developer, and core concepts.

AI Concepts & LLM Setup 5

AI concepts for Oracle developers, and connecting the database to Gemini or a local LLM.

Vectors & Embeddings 9

The VECTOR data type, distance, embedding models, and vector indexes.

LLMs & RAG in PL/SQL 8

Call LLMs from SQL and PL/SQL, classify and extract data, RAG, and natural-language SQL.

AI Security & Production 6

Redaction, prompt injection, row-level security, cost, background jobs, and deployment.

SQL Essentials 15

Create tables, query and change data, data types, joins, and execution plans.

SQL Query Recipes 12

Real analytics queries: running totals, gaps and islands, cohorts, churn, and JSON.

PL/SQL Essentials 16

Blocks, variables, control flow, cursors, exceptions, procedures, packages, and triggers.

Books 2

The Oracle Database 26ai books.