html

• 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
• Overview of JSON-Relational Duality Views
  • Table-Centric Use Case for JSON-Relational Duality
  • Document-Centric Use Case for JSON-Relational Duality
  • Map JSON Documents, Not Programming Objects
  • Duality-View Security: Simple, Centralized, Use-Case-Specific
  • Oracle AI Database: Converged, Multitenant, Backed By SQL
• Introduction To Car-Racing Duality Views Example
  • Car-Racing Example, JSON Documents
  • Car-Racing Example, Entity Relationships
  • Car-Racing Example, Tables
• Creating Duality Views
  • Creating Car-Racing Duality Views Using SQL
  • Creating Car-Racing Duality Views Using GraphQL
  • WHERE Clauses in Duality-View Tables
  • On Duality-View Nesting and Unnesting
  • Specify User-Defined Identifying Keys
  • Hide or Omit Identifying Key Fields
  • Control Null Values in Duality-View Documents
  • Return Arrays of Scalar Values
  • Limit Nested Arrays
• Updatable JSON-Relational Duality Views
  • Annotations (NO)UPDATE, (NO)INSERT, (NO)DELETE, To Allow/Disallow Updating Operations
  • Annotation (NO)CHECK, To Include/Exclude Fields for ETAG Calculation
  • Database Privileges Needed for Duality-View Updating Operations
  • Rules for Updating Duality Views
• Using JSON-Relational Duality Views
  • Inserting Documents/Data Into Duality Views
  • Deleting Documents/Data From Duality Views
  • Updating Documents/Data in Duality Views
    • Trigger Considerations When Using Duality Views
  • Using Optimistic Concurrency Control With Duality Views
    • Using Duality-View Transactions
  • Using the System Change Number (SCN) of a JSON Document
  • Optimization of Operations on Duality-View Documents
  • Obtaining Information About a Duality View
• Document-Identifier Field for Duality Views
• Schema Flexibility with JSON Columns in Duality Views
  • Embedding Values from JSON Columns into Documents
  • Merging Fields from JSON Flex Columns into Documents
  • When To Use JSON-Type Columns for a Duality View
  • Flex Columns, Beyond the Basics
• Inline Augmentation: JSON Field Generation
  • Inline Read Augmentation
  • Inline Write Augmentation
• Duality View Directives
  • Validation Directives
    • Creating Validation Directives
    • Car-Racing Validation Directive Examples
    • Altering or Dropping an Existing Validation Directive
    • Data Dictionary Views for Listing Directives
  • Notification Directives
    • Creating Notification Directives
      • Creating Notification Directives on Tables
      • Creating Notification Directives on JSON-Relational Duality Views
    • Altering or Dropping an Existing Notification Directive
    • Purging Notification History
    • Data Dictionary Views for Listing Notification Directives
• GraphQL Language Used for JSON-Relational Duality Views
  • Oracle Supported GraphQL Directives for JSON-Relational Duality Views
    • Oracle GraphQL Directive @link
• Schema Evolution with JSON-Relational Duality Views
  • Create an Initial Duality View
  • Add Fields to an API
  • Remove a Field from an API
  • Reformat a Field in an API
  • Split a Field into Multiple Fields
  • Move Embedded Data to Shared Data
  • Move Fields to Nested Objects
  • Add a Parent Object Above Nested Objects
  • Convert a Scalar Field to a Scalar Array
  • Use a JSON Type Column for Flexible Extension
• Index