Skip to Main Content
26ai Duality Views: Build Updatable JSON Documents

About This Workshop

Youtube Video

About This Workshop
In this hands-on, bite-sized lab (15 to 20 minutes), you will build a small conference schema, create single-table and multi-table JSON Relational Duality Views, and perform full CRUD operations through the document interface. The lab also demonstrates querying nested JSON documents with SQL using JSON_TABLE and applying fine-grained controls such as read-only attributes.

This workshop is designed as a concise introduction to JSON Relational Duality Views and uses embedded FreeSQL worksheets directly within the LiveLabs experience, allowing participants to run SQL and explore Oracle Database 26ai features without leaving the lab. For a more comprehensive, in-depth walkthrough of JSON Relational Duality Views, including additional scenarios and advanced coverage, participants are encouraged to explore the full LiveLabs workshop available here: https://livelabs.oracle.com/ords/r/dbpm/livelabs/view-workshop?clear=RR,180&wid=3968&session=110491904301514

Workshop Info

15 minutes
  • Create a small relational schema for a conference application
  • Create single-table JSON Relational Duality Views
  • Create a multi-table JSON Relational Duality View with nested documents
  • Perform CRUD operations through JSON documents
  • Query nested JSON documents using SQL
  • Basic familiarity with SQL (SELECT, INSERT, UPDATE, DELETE)
  • General understanding of relational database concepts
  • Basic familiarity with JSON objects and arrays is helpful but not required
  • FreeSQL account created

Other Workshops you might like