List of Examples

• 1-1        A JSON Object (Representation of a JavaScript Object Literal)
• 2-1        Converting Textual JSON Data to JSON Type On the Fly
• 2-2        Adding Time Zone Information to JSON Data
• 2-3        Using JSON_SERIALIZE To Convert JSON type or BLOB Data To Pretty-Printed Text
• 2-4        Using JSON_SERIALIZE To Convert Non-ASCII Unicode Characters to ASCII Escape Codes
• 4-1        Creating a Table with a JSON Type Column
• 4-2        Using IS JSON in a Check Constraint to Ensure Textual JSON Data is Well-Formed
• 4-3        Inserting JSON Data Into a JSON Column
• 5-1        Using IS JSON in a Check Constraint to Ensure Textual JSON Data is Strictly Well-Formed
• 7-1        JDBC Client: Using the LOB Locator Interface To Retrieve JSON BLOB Data
• 7-2        JDBC Client: Using the LOB Locator Interface To Retrieve JSON CLOB Data
• 7-3        ODP.NET Client: Using the LOB Locator Interface To Retrieve JSON BLOB Data
• 7-4        ODP.NET Client: Using the LOB Locator Interface To Retrieve JSON CLOB Data
• 7-5        JDBC Client: Using the LOB Data Interface To Retrieve JSON BLOB Data
• 7-6        JDBC Client: Using the LOB Data Interface To Retrieve JSON CLOB Data
• 7-7        JDBC Client: Reading Full BLOB Content Directly with getBytes
• 7-8        JDBC Client:Reading Full CLOB Content Directly with getString
• 7-9        ODP.NET Client: Reading Full BLOB Content Directly with getBytes
• 7-10      ODP.NET Client: Reading Full CLOB Content Directly with getString
• 8-1        Creating a Partitioned Table Using a JSON Virtual Column
• 11-1      Updating a JSON Column Using JSON_TRANSFORM
• 11-2      Modifying JSON Data On the Fly With JSON_TRANSFORM
• 11-3      Adding a Field Using JSON_TRANSFORM
• 11-4      Removing a Field Using JSON_TRANSFORM
• 11-5      Creating or Replacing a Field Value Using JSON_TRANSFORM
• 11-6      Replacing an Existing Field Value Using JSON_TRANSFORM
• 11-7      Using FORMAT JSON To Set a JSON Boolean Value
• 11-8      Setting an Array Element Using JSON_TRANSFORM
• 11-9      Prepending an Array Element Using JSON_TRANSFORM
• 11-10    Appending an Array Element Using JSON_TRANSFORM
• 11-11    Removing Array Elements That Satisfy a Predicate Using JSON_TRANSFORM
• 12-1      A JSON Merge Patch Document
• 12-2      A Merge-Patched JSON Document
• 12-3      Updating a JSON Column Using JSON_MERGEPATCH
• 12-4      Modifying JSON Data On the Fly With JSON_MERGEPATCH
• 13-1      Creating a Database Directory Object for Purchase Orders
• 13-2      Creating an External Table and Filling It From a JSON Dump File
• 13-3      Creating a Table With a BLOB Column for JSON Data
• 13-4      Copying JSON Data From an External Table To a Database Table
• 14-1      JSON Dot-Notation Query Compared With JSON_VALUE
• 14-2      JSON Dot-Notation Query Compared With JSON_QUERY
• 15-1      Aggregating Values of a Field for Each Document
• 15-2      Aggregating Values of a Field Across All Documents
• 16-1      Using ON MISMATCH Clauses
• 17-1      JSON_EXISTS: Path Expression Without Filter
• 17-2      JSON_EXISTS: Current Item and Scope in Path Expression Filters
• 17-3      JSON_EXISTS: Filter Conditions Depend On the Current Item
• 17-4      JSON_EXISTS: Filter Downscoping
• 17-5      JSON_EXISTS: Path Expression Using Path-Expression exists Condition
• 17-6      JSON_EXISTS Expressed Using JSON_TABLE
• 18-1      JSON_VALUE: Returning a JSON Boolean Value to SQL as VARCHAR2
• 18-2      JSON_VALUE: Returning a JSON Boolean Value to SQL as NUMBER
• 18-3      JSON_VALUE: Returning a JSON Boolean Value to PL/SQL as BOOLEAN
• 18-4      Instantiate a User-Defined Object Instance From JSON Data with JSON_VALUE
• 18-5      Instantiate a Collection Type Instance From JSON Data with JSON_VALUE
• 18-6      JSON_VALUE Expressed Using JSON_TABLE
• 19-1      Selecting JSON Values Using JSON_QUERY
• 19-2      JSON_QUERY Expressed Using JSON_TABLE
• 20-1      Equivalent JSON_TABLE Queries: Simple and Full Syntax
• 20-2      Equivalent: SQL NESTED and JSON_TABLE with LEFT OUTER JOIN
• 20-3      Using SQL NESTED To Expand a Nested Array
• 20-4      Accessing JSON Data Multiple Times to Extract Data
• 20-5      Using JSON_TABLE to Extract Data Without Multiple Parses
• 20-6      Projecting an Entire JSON Array as JSON Data
• 20-7      Projecting Elements of a JSON Array
• 20-8      Projecting Elements of a JSON Array Plus Other Data
• 20-9      JSON_TABLE: Projecting Array Elements Using NESTED
• 20-10    Creating a View Over JSON Data
• 20-11    Creating a Materialized View Over JSON Data
• 21-1      Full-Text Query of JSON Data with JSON_TEXTCONTAINS
• 22-1      Enabling Persistent Support for a JSON Data Guide But Not For Search
• 22-2      Disabling JSON Data-Guide Support For an Existing JSON Search Index
• 22-3      Gathering Statistics on JSON Data Using a JSON Search Index
• 22-4      Specifying Preferred Column Names For Some JSON Fields
• 22-5      Creating a View Using a Hierarchical Data Guide Obtained With JSON_DATAGUIDE
• 22-6      Creating a View That Projects All Scalar Fields
• 22-7      Creating a View That Projects Scalar Fields Targeted By a Path Expression
• 22-8      Creating a View That Projects Scalar Fields Having a Given Frequency
• 22-9      Adding Virtual Columns That Project JSON Fields Using a Data Guide Obtained With JSON_DATAGUIDE
• 22-10    Adding Virtual Columns, Hidden and Visible
• 22-11    Projecting All Scalar Fields Not Under an Array as Virtual Columns
• 22-12    Projecting Scalar Fields With a Minimum Frequency as Virtual Columns
• 22-13    Projecting Scalar Fields With a Minimum Frequency as Hidden Virtual Columns
• 22-14    Dropping Virtual Columns Projected From JSON Fields
• 22-15    Adding Virtual Columns Automatically With Change Trigger ADD_VC
• 22-16    Tracing Data-Guide Updates With a User-Defined Change Trigger
• 22-17    Adding a 2015 Purchase-Order Document
• 22-18    Adding a 2016 Purchase-Order Document
• 22-19    Creating Multiple Data Guides With Aggregate Function JSON_DATAGUIDE
• 22-20    Querying a Data Guide Obtained Using JSON_DATAGUIDE
• 22-21    Querying a Data Guide With Index Data For Paths With Frequency at Least 80%
• 22-22    Flat Data Guide For Purchase Orders
• 22-23    Hierarchical Data Guide For Purchase Orders
• 23-1      Declaring an Input Value To Be JSON
• 23-2      Using Name–Value Pairs with JSON_OBJECT
• 23-3      Using Column Names with JSON_OBJECT
• 23-4      Using a Wildcard (*) with JSON_OBJECT
• 23-5      Using JSON_OBJECT With ABSENT ON NULL
• 23-6      Using a User-Defined Object-Type Instance with JSON_OBJECT
• 23-7      Using JSON_ARRAY to Construct a JSON Array
• 23-8      Using JSON_OBJECTAGG to Construct a JSON Object
• 23-9      Using JSON_ARRAYAGG to Construct a JSON Array
• 23-10    Generating JSON Objects with Nested Arrays Using a SQL Subquery
• 25-1      Constructing and Serializing an In-Memory JSON Object
• 25-2      Using Method GET_KEYS() to Obtain a List of Object Fields
• 25-3      Using Method PUT() to Update Parts of JSON Documents
• 26-1      A Table With GeoJSON Data
• 26-2      Selecting a geometry Object From a GeoJSON Feature As an SDO_GEOMETRY Instance
• 26-3      Retrieving Multiple geometry Objects From a GeoJSON Feature As SDO_GEOMETRY
• 26-4      Creating a Spatial Index For Scalar GeoJSON Data
• 26-5      Using GeoJSON Geometry With Spatial Operators
• 26-6      Creating a Materialized View Over GeoJSON Data
• 26-7      Creating a Spatial Index on a Materialized View Over GeoJSON Data
• 28-1      Creating a Bitmap Index for JSON_VALUE
• 28-2      Creating a Function-Based Index for a JSON Field: Dot Notation
• 28-3      Creating a Function-Based Index for a JSON Field: JSON_VALUE
• 28-4      Specifying NULL ON EMPTY for a JSON_VALUE Function-Based Index
• 28-5      Use of a JSON_VALUE Function-Based Index with a JSON_TABLE Query
• 28-6      JSON_EXISTS Query Targeting Field Compared to Literal Number
• 28-7      JSON_EXISTS Query Targeting Field Compared to Variable Value
• 28-8      JSON_EXISTS Query Targeting Field Cast to Number Compared to Variable Value
• 28-9      JSON_EXISTS Query Targeting a Conjunction of Field Comparisons
• 28-10    JSON_VALUE Query with Explicit RETURNING NUMBER
• 28-11    JSON_VALUE Query with Explicit Numerical Conversion
• 28-12    JSON_VALUE Query with Implicit Numerical Conversion
• 28-13    Table PARTS_TAB, for Multivalue Index Examples
• 28-14    Creating a Multivalue Index for JSON_EXISTS
• 28-15    Creating a Composite Multivalue Index for JSON_EXISTS
• 28-16    Creating a Composite Multivalue Index That Can Target Array Positions
• 28-17    JSON_EXISTS Query With Item Method numberOnly()
• 28-18    JSON_EXISTS Query Without Item Method numberOnly()
• 28-19    JSON_EXISTS Query Checking Multiple Fields
• 28-20    JSON_EXISTS Query Checking Array Element Position
• 28-21    Creating a Composite B-tree Index For JSON Object Fields
• 28-22    Querying JSON Data Indexed With a Composite B-tree Index
• 28-23    Creating a JSON Search Index That Is Synchronized On Commit
• 28-24    Creating a JSON Search Index That Is Synchronized Each Second
• 28-25    Execution Plan Indication that a JSON Search Index Is Used
• 28-26    Some Ad Hoc JSON Queries
• 29-1      Populating JSON Data Into the IM Column Store For Ad Hoc Query Support
• 29-2      Populating a JSON Type Column Into the IM Column Store For Full-Text Query Support
• 30-1      Creating a Materialized View of JSON Data To Support Query Rewrite
• 30-2      Creating an Index Over a Materialized View of JSON Data