List of Examples

• 2-1        A Team Document
• 2-2        A Driver Document
• 2-3        A Car-Race Document
• 2-4        Creating the Car-Racing Tables
• 2-5        Creating Duality View TEAM_DV Using SQL
• 2-6        Creating Duality View DRIVER_DV, With Nested Team Information Using SQL
• 2-7        Creating Duality View DRIVER_DV, With Unnested Team Information Using SQL
• 2-8        Creating Duality View RACE_DV, With Nested Driver Information Using SQL
• 2-9        Creating Duality View RACE_DV, With Unnested Driver Information Using SQL
• 2-10      Creating Duality View TEAM_DV Using GraphQL
• 2-11      Creating Duality View DRIVER_DV Using GraphQL
• 2-12      Creating Duality View RACE_DV Using GraphQL
• 4-1        Inserting JSON Documents into Duality Views, Providing Primary-Key Fields — Using SQL
• 4-2        Inserting JSON Documents into Duality Views, Providing Primary-Key Fields — Using REST
• 4-3        Inserting JSON Data into Tables
• 4-4        Inserting a JSON Document into a Duality View Without Providing Primary-Key Fields — Using SQL
• 4-5        Inserting a JSON Document into a Duality View Without Providing Primary-Key Fields — Using REST
• 4-6        Deleting a JSON Document from Duality View RACE_DV — Using SQL
• 4-7        Deleting a JSON Document from Duality View RACE_DV — Using REST
• 4-8        Updating an Entire JSON Document in a Duality View — Using SQL
• 4-9        Updating an Entire JSON Document in a Duality View — Using REST
• 4-10      Updating Part of a JSON Document in a Duality View
• 4-11      Updating Interrelated JSON Documents — Using SQL
• 4-12      Updating Interrelated JSON Documents — Using REST
• 4-13      Attempting a Disallowed Updating Operation Raises an Error — Using SQL
• 4-14      Attempting a Disallowed Updating Operation Raises an Error — Using REST
• 4-15      Using a Trigger To Update Driver Points Based On Car-Race Position
• 4-16      Obtain the Current ETAG Value for a Race Document From Field etag — Using SQL
• 4-17      Obtain the Current ETAG Value for a Race Document From Field etag — Using REST
• 4-18      Using Function SYS_ROW_ETAG To Optimistically Control Concurrent Table Updates
• 4-19      Locking Duality-View Documents For Update
• 4-20      Using a Duality-View Transaction To Optimistically Update Two Documents Concurrently
• 4-21      Obtain the SCN Recorded When a Document Was Fetched
• 4-22      Retrieve a Race Document As Of the Moment Another Race Document Was Retrieved
• 4-23      Using DBMS_JSON_SCHEMA.DESCRIBE To Show JSON Schemas Describing Duality Views
• 5-1        Document Identifier Not Compatible with MongoDB API
• 5-2        Document Identifier for MongoDB API Compatibility: Primary-Key Column Value
• 5-3        Document Identifier for MongoDB API Compatibility: Object Value
• 7-1        Creating Duality View DRIVER_DV1, With Nested Driver Information
• 7-2        Creating Table TEAM_W_LEAD With LEAD_DRIVER Column
• 7-3        Creating Duality Views TEAM_DV2 With LEAD_DRIVER, Showing GraphQL Directive @link
• 7-4        Creating Duality View DRIVER_DV2, Showing GraphQL Directive @link