JSON in the Oracle Database (26ai)

With 26ai, JSON becomes a first-class data model in Oracle. The workshop covers the native type and the new features and goes deep into JSON Relational Duality Views: relational tables that applications read and write like documents.

Audience

Developers and architects on Oracle 23ai/26ai or about to move.

Modules

The modules are building blocks. You choose and weight them, and we agree on the agenda together beforehand.

• Native JSON data type: OSON, storage, performance, migrating from CLOB and BLOB
• JSON Schema: validation, type checking, deriving a schema from data
• JSON collection tables: document-oriented work in SQL
• Duality Views: structure, annotations for insert, update and delete, ETags and lock-free concurrency
• Duality Views in practice: REST via ORDS, MongoDB API, use cases and limits
• New functions: JSON_TRANSFORM, SQL/JSON extensions, domains for JSON
• Fundamentals from 19c: querying, generating and indexing as needed

Outcome

A data model from your environment, exposed through Duality Views, and an assessment of where JSON fits in your architecture.

Preview

For a first look: the talks on this topic give you an overview, and the talk pages include the slides.

• Oracle 26ai: JSON Features Beyond Duality Views Oracle ACE Live 2026