Table of Contents

• List of Examples
• List of Figures
• List of Tables
• Title and Copyright Information
• Preface
  • Audience
  • Related Documents
  • Conventions
  • Code Examples
    • Pretty Printing of JSON Data
    • Execution Plans
    • Reminder About Case Sensitivity
• Part I JSON Data and Oracle AI Database
  • 1 JSON Data (Standard)
    • Overview of JSON
    • JSON Syntax and the Data It Represents
    • JSON Compared with XML
  • 2 JSON in Oracle AI Database
    • Overview of JSON in Oracle AI Database
      • Data Types for JSON Data
      • JSON null and SQL NULL
      • JSON Columns in Database Tables
      • Use SQL with JSON Data
      • Use PL/SQL with JSON Data
      • Use JavaScript with JSON Data
    • JSON Data Type
      • JSON Data Type Constructor
      • SQL/JSON Function JSON_SCALAR
      • SQL/JSON Function JSON_SERIALIZE
      • JSON Constructor, JSON_SCALAR, and JSON_SERIALIZE: Summary
      • Textual JSON Objects That Represent Extended Scalar Values
      • Comparison and Sorting of JSON Data Type Values
      • Comparison of SQL Values With JSON Data Type Values
    • Oracle AI Database Support for JSON
      • Support for RFC 8259: JSON Scalars
• Part II Store and Manage JSON Data
  • 3 Overview of Storing and Managing JSON Data
  • 4 Tables With JSON Columns
    • Creating Tables With JSON Columns
    • Limiting the Data in JSON-Type Columns
    • Determining Whether a Column Must Contain Only JSON Data
  • 5 SQL/JSON Conditions IS JSON and IS NOT JSON
    • Unique Versus Duplicate Fields in JSON Objects
    • Strict and Lax JSON Syntax
    • Specifying Strict JSON Syntax for Condition IS JSON
  • 6 JSON Collections
  • 7 JSON Schema
    • Validating JSON Data with a JSON Schema
    • JSON Schema Validation With Type Casting To Extended Scalar Values
    • Generating JSON Schemas
    • JSON Schemas Generated with DBMS_JSON_SCHEMA.DESCRIBE
    • Explicitly Declaring Column Check Constraints Precheckable or Not
  • 8 Character Sets and Character Encoding for JSON Data
  • 9 Considerations When Using LOB Storage for JSON Data
  • 10 Partitioning JSON Data
  • 11 Replication of JSON Data
• Part III Insert, Update, and Load JSON Data
  • 12 Overview of Inserting, Updating, and Loading JSON Data
  • 13 Oracle SQL Function JSON_TRANSFORM
    • Use Bind Variables With JSON_TRANSFORM
    • JSON_TRANSFORM Operations, Including Assignments
    • JSON_TRANSFORM Operator ADD_SET
    • JSON_TRANSFORM Operator APPEND
    • JSON_TRANSFORM Operator CASE
    • JSON_TRANSFORM Operator COPY
    • JSON_TRANSFORM Operator INSERT
    • JSON_TRANSFORM Operator INTERSECT
    • JSON_TRANSFORM Operator KEEP
    • JSON_TRANSFORM Operator MERGE
    • JSON_TRANSFORM Operator MINUS
    • JSON_TRANSFORM Operator NESTED PATH
    • JSON_TRANSFORM Operator PREPEND
    • JSON_TRANSFORM Operator REMOVE
    • JSON_TRANSFORM Operator REMOVE_SET
    • JSON_TRANSFORM Operator RENAME
    • JSON_TRANSFORM Operator REPLACE
    • JSON_TRANSFORM Operator SET
    • JSON_TRANSFORM Operator SORT
    • JSON_TRANSFORM Operator UNION
    • JSON_TRANSFORM Right-Hand-Side (RHS) Path Expressions
    • JSON_TRANSFORM Operation Handlers
  • 14 Oracle SQL Function JSON_MERGEPATCH
  • 15 Loading External JSON Data
• Part IV Query JSON Data
  • 16 Simple Dot-Notation Access to JSON Data
  • 17 SQL/JSON Path Expressions
    • Overview of SQL/JSON Path Expressions
    • SQL/JSON Path Expression Syntax
      • Basic SQL/JSON Path Expression Syntax
      • SQL/JSON Path Expression Syntax Relaxation
      • Negation in Path Expressions
    • SQL/JSON Path Expression Item Methods
    • Types in Filter-Condition Comparisons
  • 18 Clauses Used in SQL Functions and Conditions for JSON
    • PASSING Clause for SQL Functions and Conditions
    • RETURNING Clause for SQL Functions
    • Wrapper Clause for SQL/JSON Query Functions JSON_QUERY and JSON_TABLE
    • Error Clause for SQL Functions and Conditions
    • Empty-Field Clause for SQL/JSON Query Functions
    • ON MISMATCH Clause for SQL/JSON Query Functions
    • TYPE Clause for SQL Functions and Conditions
  • 19 SQL/JSON Condition JSON_EXISTS
    • Using Filters with JSON_EXISTS
    • JSON_EXISTS as JSON_TABLE
  • 20 SQL/JSON Function JSON_QUERY
    • JSON_QUERY as JSON_TABLE
  • 21 SQL/JSON Function JSON_TABLE
    • SQL NESTED Clause Instead of JSON_TABLE
    • COLUMNS Clause of SQL/JSON Function JSON_TABLE
    • JSON_TABLE Generalizes SQL/JSON Query Functions and Conditions
    • Using JSON_TABLE with JSON Arrays
    • Creating a View Over JSON Data Using JSON_TABLE
  • 22 SQL/JSON Function JSON_VALUE
    • Using SQL/JSON Function JSON_VALUE With a Boolean JSON Value
    • Using JSON_VALUE To Instantiate a User-Defined Object-Type or Collection-Type Instance
    • JSON_VALUE as JSON_TABLE
  • 23 Full-Text Search Queries
    • Oracle SQL Condition JSON_TEXTCONTAINS
    • JSON Facet Search with PL/SQL Procedure CTX_QUERY.RESULT_SET
  • 24 JSON Data Guide
    • Overview of JSON Data Guide
    • Persistent Data-Guide Information as Part of a JSON Search Index
    • Data-Guide Formats and Ways of Creating a Data Guide
    • JSON Data-Guide Fields
    • Data-Dictionary Views For Persistent Data-Guide Information
    • Specifying a Preferred Name for a Field Column
    • Creating a View Over JSON Data Based on Data-Guide Information
      • Creating a View Over JSON Data Based on a Hierarchical or Schema Data Guide
      • Creating a View Over JSON Data Based on a Path Expression
    • Adding and Dropping Virtual Columns For JSON Fields Based on Data-Guide Information
      • Adding Virtual Columns For JSON Fields Based on a Hierarchical or Schema Data Guide
      • Adding Virtual Columns For JSON Fields Based on a Data Guide-Enabled Search Index
      • Dropping Virtual Columns for JSON Fields Based on Data-Guide Information
    • Change Triggers For Data Guide-Enabled Search Index
      • User-Defined Data-Guide Change Triggers
    • Multiple Data Guides Per Document Set
    • Querying a Data Guide
    • A Flat Data Guide For Purchase-Order Documents
    • A Hierarchical Data Guide For Purchase-Order Documents
    • A Schema Data Guide For Purchase-Order Documents
• Part V Generation of JSON Data
  • 25 Generation of JSON Data Using SQL
    • Overview of JSON Generation
    • Handling of Input Values For SQL/JSON Generation Functions
    • SQL/JSON Function JSON_OBJECT
    • SQL/JSON Function JSON_ARRAY
    • SQL/JSON Function JSON_OBJECTAGG
    • SQL/JSON Function JSON_ARRAYAGG
    • Read-Only Views Based On JSON Generation
• Part VI PL/SQL Object Types for JSON
  • 26 Overview of PL/SQL Object Types for JSON
  • 27 Using PL/SQL Object Types for JSON
• Part VII GeoJSON Geographic Data
  • 28 Using GeoJSON Geographic Data
• Part VIII Performance Tuning for JSON
  • 29 Overview of Performance Tuning for JSON
  • 30 Indexes for JSON Data
    • Overview of Indexing JSON Data
    • How To Tell Whether a Function-Based Index for JSON Data Is Picked Up
    • Creating Bitmap Indexes for JSON_VALUE
    • Creating B-Tree Indexes for JSON_VALUE
    • Using a JSON_VALUE Function-Based Index with JSON_TABLE Queries
    • Using a JSON_VALUE Function-Based Index with JSON_EXISTS Queries
    • Data Type Considerations for JSON_VALUE Indexing and Querying
    • Creating Multivalue Function-Based Indexes for JSON_EXISTS
    • Simplified Dot Notation Syntax for JSON Index Creation
    • Using a Multivalue Function-Based Index
    • Indexing Multiple JSON Fields Using a Composite B-Tree Index
    • JSON Search Index for Ad Hoc Queries and Full-Text Search
  • 31 In-Memory JSON Data
    • Overview of In-Memory JSON Data
    • Populating JSON Data Into the In-Memory Column Store
    • Upgrading Tables With JSON Data For Use With the In-Memory Column Store
  • 32 JSON Query Rewrite To Use a Materialized View Over JSON_TABLE
• Appendixes
  • A ISO 8601 Date, Time, and Duration Support
  • B Oracle AI Database JSON Capabilities Specification
  • C Diagrams for Basic SQL/JSON Path Expression Syntax
  • D Migrating Textual JSON Data to JSON Data Type
    • Performing a Pre-Migration Check
    • Populate JSON-Type Column By Querying Textual JSON
    • Using Oracle Data Pump to Migrate to JSON Data Type
    • Using Online Redefinition to Migrate to JSON Data Type
    • Handling Dependent Objects
• Index