Table of Contents

• List of Examples
• List of Figures
• List of Tables
• Title and Copyright Information
• Preface
  • Audience
  • Documentation Accessibility
  • Diversity and Inclusion
  • Related Documents
  • Conventions
  • Code Examples
    • Pretty Printing of JSON Data
    • Reminder About Case Sensitivity
• 1 Overview of JSON-Relational Duality Views
  • 1.1 Table-Centric Use Case for JSON-Relational Duality
  • 1.2 Document-Centric Use Case for JSON-Relational Duality
  • 1.3 Map JSON Documents, Not Programming Objects
  • 1.4 Duality-View Security: Simple, Centralized, Use-Case-Specific
  • 1.5 Oracle Database: Converged, Multitenant, Backed By SQL
• 2 Introduction To Car-Racing Duality Views Example
  • 2.1 Car-Racing Example, JSON Documents
  • 2.2 Car-Racing Example, Entity Relationships
  • 2.3 Car-Racing Example, Tables
• 3 Creating Duality Views
  • 3.1 Creating Car-Racing Duality Views Using SQL
  • 3.2 Creating Car-Racing Duality Views Using GraphQL
  • 3.3 WHERE Clauses in Duality-View Tables
• 4 Updatable JSON-Relational Duality Views
  • 4.1 Annotations (NO)UPDATE, (NO)INSERT, (NO)DELETE, To Allow/Disallow Updating Operations
  • 4.2 Annotation (NO)CHECK, To Include/Exclude Fields for ETAG Calculation
  • 4.3 Database Privileges Needed for Duality-View Updating Operations
  • 4.4 Rules for Updating Duality Views
• 5 Using JSON-Relational Duality Views
  • 5.1 Inserting Documents/Data Into Duality Views
  • 5.2 Deleting Documents/Data From Duality Views
  • 5.3 Updating Documents/Data in Duality Views
    • 5.3.1 Trigger Considerations When Using Duality Views
  • 5.4 Using Optimistic Concurrency Control With Duality Views
    • 5.4.1 Using Duality-View Transactions
  • 5.5 Using the System Change Number (SCN) of a JSON Document
  • 5.6 Optimization of Operations on Duality-View Documents
  • 5.7 Obtaining Information About a Duality View
• 6 Document-Identifier Field for Duality Views
• 7 Generated Fields, Hidden Fields
• 8 Schema Flexibility with JSON Columns in Duality Views
  • 8.1 Embedding Values from JSON Columns into Documents
  • 8.2 Merging Fields from JSON Flex Columns into Documents
  • 8.3 When To Use JSON-Type Columns for a Duality View
  • 8.4 Flex Columns, Beyond the Basics
• 9 GraphQL Language Used for JSON-Relational Duality Views
  • 9.1 Oracle GraphQL Directives for JSON-Relational Duality Views
    • 9.1.1 Oracle GraphQL Directive @link
• Index