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
- 3-1 Creating Duality View TEAM_DV Using SQL
- 3-2 Creating Duality View DRIVER_DV, With Nested Team Information Using SQL
- 3-3 Creating Duality View DRIVER_DV, With Unnested Team Information Using SQL
- 3-4 Creating Duality View RACE_DV, With Nested Driver Information Using SQL
- 3-5 Creating Duality View RACE_DV, With Unnested Driver Information Using SQL
- 3-6 Creating Duality View TEAM_DV Using GraphQL
- 3-7 Creating Duality View DRIVER_DV Using GraphQL
- 3-8 Creating Duality View RACE_DV Using GraphQL
- 3-9 WHERE Clause Use in Duality View Definition (SQL)
- 3-10 WHERE Clause Use in Duality View Definition (GraphQL)
- 5-1 Inserting JSON Documents into Duality Views, Providing Document-Identifier Fields — Using SQL
- 5-2 Inserting JSON Documents into Duality Views, Providing Document-Identifier Fields — Using REST
- 5-3 Inserting JSON Data into Tables
- 5-4 Inserting a JSON Document into a Duality View Without Providing Document-Identifier Fields — Using SQL
- 5-5 Inserting a JSON Document into a Duality View Without Providing Document-Identifier Fields — Using REST
- 5-6 Deleting a JSON Document from Duality View RACE_DV — Using SQL
- 5-7 Deleting a JSON Document from Duality View RACE_DV — Using REST
- 5-8 Updating an Entire JSON Document in a Duality View — Using SQL
- 5-9 Updating an Entire JSON Document in a Duality View — Using REST
- 5-10 Updating Part of a JSON Document in a Duality View
- 5-11 Updating Interrelated JSON Documents — Using SQL
- 5-12 Updating Interrelated JSON Documents — Using REST
- 5-13 Attempting a Disallowed Updating Operation Raises an Error — Using SQL
- 5-14 Attempting a Disallowed Updating Operation Raises an Error — Using REST
- 5-15 Obtain the Current ETAG Value for a Race Document From Field etag — Using SQL
- 5-16 Obtain the Current ETAG Value for a Race Document From Field etag — Using REST
- 5-17 Using Function SYS_ROW_ETAG To Optimistically Control Concurrent Table Updates
- 5-18 Locking Duality-View Documents For Update
- 5-19 Using a Duality-View Transaction To Optimistically Update Two Documents Concurrently
- 5-20 Obtain the SCN Recorded When a Document Was Fetched
- 5-21 Retrieve a Race Document As Of the Moment Another Race Document Was Retrieved
- 5-22 Using DBMS_JSON_SCHEMA.DESCRIBE To Show JSON Schemas Describing Duality Views
- 6-1 Document Identifier Field _id With Primary-Key Column Value
- 6-2 Document Identifier Field _id With Object Value
- 7-1 Fields Generated Using a SQL Query and a SQL Expression
- 7-2 Field Generated Using a SQL/JSON Path Expression
- 7-3 Fields Generated Using Hidden Fields
- 9-1 Creating Duality View DRIVER_DV1, With Nested Driver Information
- 9-2 Creating Table TEAM_W_LEAD With LEAD_DRIVER Column
- 9-3 Creating Duality View TEAM_DV2 With LEAD_DRIVER, Showing GraphQL Directive @link
- 9-4 Creating Duality View DRIVER_DV2, Showing GraphQL Directive @link
- 9-5 Creating Table DRIVER_W_MGR With Column MANAGER_ID
- 9-6 Creating Duality View TEAM_DV3 (Drivers with Managers)
- 9-7 Creating Duality View DRIVER_DV3 (Drivers with Managers)
- 9-8 Creating Duality View DRIVER_MANAGER_DV