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
- 2-13 WHERE Clause Use in Duality View Definition (SQL)
- 2-14 WHERE Clause Use in Duality View Definition (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 Field _id: Primary-Key Column Value
- 5-2 Document Identifier Field _id: Object Value
- 7-1 Student Document Set (Migrator Input)
- 7-2 Teacher Document Set (Migrator Input)
- 7-3 Course Document Set (Migrator Input)
- 7-4 Create an Oracle Document Set (Course) From a JSON Dump File.
- 7-5 Create a JSON Schema For Course Input Document Set
- 7-6 Create JSON Data Guides For Student and Course Document Set
- 7-7 JSON Data Guide For Input Student Document Set
- 7-8 JSON Data Guide For Input Course Document Set
- 7-9 Infer Database Objects and Generate Their DDL (Configured With Flex Columns)
- 7-10 DDL Generated For Tables (useFlexFields:true)
- 7-11 DDL Generated For Duality Views (useFlexFields:true)
- 7-12 SQL DDL Code For Duality-View Creations (useFlexFields:true)
- 7-13 Create a JSON Schema for the Course Duality View
- 7-14 Infer Database Objects and Generate Their DDL (Configured Without Flex Columns)
- 7-15 DDL Generated For Tables (useFlexFields:false)
- 7-16 DDL Generated For Duality Views (useFlexFields:false)
- 7-17 Create Error-Log Tables for Duality Views
- 7-18 Import Documents Into Duality Views
- 7-19 Student Document Set (Migrator Output, useFlexFields:true)
- 7-20 Teacher Document Set (Migrator Output, useFlexFields:true)
- 7-21 Course Document Set (Migrator Output, useFlexFields:true)
- 7-22 Show Error Log Entries for Student Import (useFlexFields:false)
- 7-23 Show Error Log Entries for Teacher Import (useFlexFields:false)
- 7-24 Show Error Log Entries for Course Import (useFlexFields:false)
- 8-1 Creating Duality View DRIVER_DV1, With Nested Driver Information
- 8-2 Creating Table TEAM_W_LEAD With LEAD_DRIVER Column
- 8-3 Creating Duality Views TEAM_DV2 With LEAD_DRIVER, Showing GraphQL Directive @link
- 8-4 Creating Duality View DRIVER_DV2, Showing GraphQL Directive @link