20 November, 2026

Using an LLM to generate Annotations and run Queries

 A video demonstration of using an LLM to

1. create "description" annotations on an Oracle Database Schema
2. query the database schema using Natural Language ("English")

The combination of tools used :
Oracle Database 26c (26.3)
Oracle SQL Developer 26.3 Extension in VSCode
Oracle sqlcl (installed with SQL Developer)
Oracle sqlcl MCP Server
GitHub Copilot
Claude Sonnet model
(Other than the Database all the tools running from within VSCode)


08 August, 2026

New JOIN TO ONE clause in 26.2 SELECT

 I've just published a short video on the new JOIN TO ONE clause in SELECT statements in Oracle 26ai 26.2

This clause allows you to let the database automatically determine JOIN columns based on Primary Key and Foreign Key relationships configured in the database.  JOIN TO ONE defaults to doing a LEFT OUTER JOIN so I also demonstrate how to use it for INNER JOINs