List of Examples

• 2-1 A JSON Object (Representation of a JavaScript Object Literal)
• 4-1 Using IS JSON in a Check Constraint to Ensure JSON Data is Well-Formed
• 4-2 Inserting JSON Data Into a VARCHAR2 JSON Column
• 5-1 Using IS JSON in a Check Constraint to Ensure JSON Data is Strictly Well-Formed (Standard)
• 7-1 Creating a Partitioned Table Using a JSON Virtual Column
• 9-1 Inserting JSON Data Into a BLOB Column
• 10-1 Creating a Database Directory Object for Purchase Orders
• 10-2 Creating an External Table and Filling It From a JSON Dump File
• 10-3 Creating a Table With a BLOB JSON Column
• 10-4 Copying JSON Data From an External Table To a Database Table
• 11-1 JSON Dot-Notation Query Compared With JSON_VALUE
• 11-2 JSON Dot-Notation Query Compared With JSON_QUERY
• 14-1 JSON_EXISTS: Path Expression Without Filter
• 14-2 JSON_EXISTS: Current Item and Scope in Path Expression Filters
• 14-3 JSON_EXISTS: Filter Conditions Depend On the Current Item
• 14-4 JSON_EXISTS: Filter Downscoping
• 14-5 JSON_EXISTS: Path Expression Using Path-Expression exists Condition
• 14-6 JSON_EXISTS Expressed Using JSON_TABLE
• 15-1 JSON_VALUE: Two Ways to Return a JSON Boolean Value in SQL
• 15-2 Returning a BOOLEAN PL/SQL Value From JSON_VALUE
• 15-3 JSON_VALUE Expressed Using JSON_TABLE
• 16-1 Selecting JSON Values Using JSON_QUERY
• 16-2 JSON_QUERY Expressed Using JSON_TABLE
• 17-1 Accessing JSON Data Multiple Times to Extract Data
• 17-2 Using JSON_TABLE to Extract Data Without Multiple Parses
• 17-3 Projecting an Entire JSON Array as JSON Data
• 17-4 Projecting Elements of a JSON Array
• 17-5 Projecting Elements of a JSON Array Plus Other Data
• 17-6 JSON_TABLE: Projecting Array Elements Using NESTED
• 17-7 Creating a View Over JSON Data
• 17-8 Creating a Materialized View Over JSON Data
• 18-1 Enabling Persistent Support for a JSON Data Guide But Not For Search
• 18-2 Disabling JSON Data-Guide Support For an Existing JSON Search Index
• 18-3 Gathering Statistics on JSON Data Using a JSON Search Index
• 18-4 Specifying Preferred Column Names For Some JSON Fields
• 18-5 Creating a View Using a Data Guide Obtained With GET_INDEX_DATAGUIDE
• 18-6 Creating a View That Projects All Scalar Fields
• 18-7 Creating a View That Projects Scalar Fields Targeted By a Path Expression
• 18-8 Creating a View That Projects Scalar Fields Having a Given Frequency
• 18-9 Adding Virtual Columns That Project JSON Fields Using a Data Guide Obtained With GET_INDEX_DATAGUIDE
• 18-10 Adding Virtual Columns, Hidden and Visible
• 18-11 Projecting All Scalar Fields Not Under an Array as Virtual Columns
• 18-12 Projecting Scalar Fields With a Minimum Frequency as Virtual Columns
• 18-13 Projecting Scalar Fields With a Minimum Frequency as Hidden Virtual Columns
• 18-14 Dropping Virtual Columns Projected From JSON Fields
• 18-15 Adding Virtual Columns Automatically With Change Trigger ADD_VC
• 18-16 Tracing Data-Guide Updates With a User-Defined Change Trigger
• 18-17 Adding a 2015 Purchase-Order Document
• 18-18 Adding a 2016 Purchase-Order Document
• 18-19 Creating Multiple Data Guides With Aggregate Function JSON_DATAGUIDE
• 18-20 Querying a Data Guide Obtained Using JSON_DATAGUIDE
• 18-21 Querying a Data Guide With Index Data For Paths With Frequency at Least 80%
• 18-22 Flat Data Guide For Purchase Orders
• 18-23 Hierarchical Data Guide For Purchase Orders
• 19-1 Declaring an Input Value To Be JSON
• 19-2 Using JSON_OBJECT to Construct JSON Objects
• 19-3 Using JSON_OBJECT With ABSENT ON NULL
• 19-4 Using JSON_ARRAY to Construct a JSON Array
• 19-5 Using JSON_OBJECTAGG to Construct a JSON Object
• 19-6 Using JSON_ARRAYAGG to Construct a JSON Array
• 21-1 Constructing and Serializing an In-Memory JSON Object
• 21-2 Using Method GET_KEYS() to Obtain a List of Object Fields
• 21-3 Using Method PUT() to Update Parts of JSON Documents
• 22-1 A Table With GeoJSON Data
• 22-2 Selecting a geometry Object From a GeoJSON Feature As an SDO_GEOMETRY Instance
• 22-3 Retrieving Multiple geometry Objects From a GeoJSON Feature As SDO_GEOMETRY
• 22-4 Creating a Spatial Index For GeoJSON Data
• 22-5 Using GeoJSON Geometry With Spatial Operators
• 24-1 Creating a Bitmap Index for JSON_EXISTS
• 24-2 Creating a Bitmap Index for JSON_VALUE
• 24-3 Creating a Function-Based Index for a JSON Field: Dot Notation
• 24-4 Creating a Function-Based Index for a JSON Field: JSON_VALUE
• 24-5 Specifying NULL ON EMPTY for a JSON_VALUE Function-Based Index
• 24-6 Use of a JSON_VALUE Function-Based Index with a JSON_TABLE Query
• 24-7 JSON_EXISTS Query Targeting Field Compared to Literal Number
• 24-8 JSON_EXISTS Query Targeting Field Compared to Variable Value
• 24-9 JSON_EXISTS Query Targeting Field Cast to Number Compared to Variable Value
• 24-10 JSON_EXISTS Query Targeting a Conjunction of Field Comparisons
• 24-11 JSON_VALUE Query with Explicit RETURNING NUMBER
• 24-12 JSON_VALUE Query with Explicit Numerical Conversion
• 24-13 JSON_VALUE Query with Implicit Numerical Conversion
• 24-14 Creating Virtual Columns For JSON Object Fields
• 24-15 Creating a Composite B-tree Index For JSON Object Fields
• 24-16 Two Ways to Query JSON Data Indexed With a Composite Index
• 24-17 Creating a JSON Search Index
• 24-18 Execution Plan Indication that a JSON Search Index Is Used
• 24-19 Full-Text Query of JSON Data
• 24-20 Full-Text Query of JSON Data, with Escaped Search Pattern
• 24-21 Some Ad Hoc JSON Queries
• 25-1 Populating JSON Data Into the IM Column Store