Build REST and GraphQL APIs with Oracle APEX JSON Relational Duality Views Session Details @oracledevs
Build REST and GraphQL APIs with Oracle APEX JSON Relational Duality Views Session Details  @oracledevs
Uploaded July 2026 | Updated November 2026, 5 days ago
Modern applications often need to expose the same business data through different API styles while keeping the underlying data model consistent. In this session, you'll learn how Oracle Database JSON Relational Duality Views, Oracle REST Data Services (ORDS), and Oracle APEX work together to expose the same relational data through both REST and GraphQL without duplicating business logic or maintaining multiple data models.



By the end of this session, you'll be able to:

Understand when JSON Relational Duality Views are appropriate.

Expose the same data model through REST and GraphQL using ORDS.

Consume both API styles from Oracle APEX.

Understand how JSON documents can be used for transactional CRUD operations while preserving relational integrity.

Apply a "single source of truth" approach to simplify API architectures and reduce duplicated models.



0:12 - 5:02 - Introduction, Announcements, and Updates - Karina Pastor

5:03 - 8:29 - Oracle ACE Program: Overview and Benefits - Marcelo Batalha

8:30 - 9:50 - Overview of the Session Topic: REST and GraphQL with Oracle APEX and Duality Views - Marcelo Batalha

9:51 - 12:57 - Exposing Data Through APIs: Challenges of API Consumption and How Different Consumers Have Different Needs - Marcelo Batalha

12:58 - 19:57 - REST APIs and GraphQL (ORDS): Comparison; Challenges of Fixed Responses; Overfetching and Underfetching; Architectural Problems in Exposing Business Data Through APIs - Marcelo Batalha

20:00 - 22:23 - JSON Relational Duality Views: Their Significance; Creating a Duality View from Relational Tables and How It Works - Marcelo Batalha

22:24 - 32:43 - Demonstration: REST API Calls and Responses Using Oracle APEX - Marcelo Batalha

32:44 - 35:52 - Demonstration: GraphQL API Calls and Responses Using Oracle APEX - Marcelo Batalha

35:53 - 42:10 - Demonstration: JSON CRUD Operations with Duality Views, Including Creating, Updating, and Deleting Records - Marcelo Batalha

42:11 - 46:33 - Summary of the Main Architectural Messages and Benefits of Using Duality Views - Marcelo Batalha

46:34 - 47:09 - Q&A - Marcelo Batalha

47:20 - 47:38 - Closing Remarks - Karina Pastor

Please share your questions about Oracle APEX on the Community Forum: apex.oracle.com/forum
Build REST and GraphQL APIs with Oracle APEX JSON Relational Duality Views Session DetailsAre You Using the Same LLM for Every Agent Task?Stale Embeddings: Why Your Vector Should Never Be the RecordMulti-Tenant AI Agent Memory: Shared Memory Is a Scope, Not a TableDurable AI Agent Memory: Old on Purpose vs Old by AccidentPart 8 - Execute the CD3 Automation toolkit using Jenkins to create resources in OCIHow to Build Web and Mobile Apps with Oracle AI DatabaseHow to Get Started with the Oracle AI Developer HubTwo Ways to Keep an AI Agent on TaskBuilding an AI Agent Workflow for Invoice ValidationTurn Past Agent Runs Into Reusable SkillsWorking with JSON and Dates in Oracle AI Database 26ai
Oracle Developers |

Build REST and GraphQL APIs with Oracle APEX JSON Relational Duality Views Session Details

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER