Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
-
Part I JSON Data and Oracle Database
- 1 JSON Data (Standard)
-
2
JSON in Oracle Database
- 2.1 Overview of JSON in Oracle Database
-
2.2
JSON Data Type
- 2.2.1 JSON Data Type Constructor
- 2.2.2 SQL/JSON Function JSON_SCALAR
- 2.2.3 SQL/JSON Function JSON_SERIALIZE
- 2.2.4 JSON Constructor, JSON_SCALAR, and JSON_SERIALIZE: Summary
- 2.2.5 Textual JSON Objects That Represent Extended Scalar Values
- 2.2.6 Comparison and Sorting of JSON Data Type Values
- 2.2.7 Comparison of SQL Values With JSON Data Type Values
- 2.3 Oracle Database Support for JSON
-
Part II Store and Manage JSON Data
- 3 Overview of Storing and Managing JSON Data
- 4 Tables With JSON Columns
- 5 SQL/JSON Conditions IS JSON and IS NOT JSON
- 6 JSON Collections
- 7 JSON Schema
- 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
-
Part IV Query JSON Data
- 16 Simple Dot-Notation Access to JSON Data
- 17 SQL/JSON Path Expressions
-
18
Clauses Used in SQL Functions and Conditions for JSON
- 18.1 PASSING Clause for SQL Functions and Conditions
- 18.2 RETURNING Clause for SQL Functions
- 18.3 Wrapper Clause for SQL/JSON Query Functions JSON_QUERY and JSON_TABLE
- 18.4 Error Clause for SQL Functions and Conditions
- 18.5 Empty-Field Clause for SQL/JSON Query Functions
- 18.6 ON MISMATCH Clause for SQL/JSON Query Functions
- 18.7 TYPE Clause for SQL Functions and Conditions
- 19 SQL/JSON Condition JSON_EXISTS
- 20 SQL/JSON Function JSON_VALUE
- 21 SQL/JSON Function JSON_QUERY
- 22 SQL/JSON Function JSON_TABLE
- 23 Full-Text Search Queries
-
24
JSON Data Guide
- 24.1 Overview of JSON Data Guide
- 24.2 Persistent Data-Guide Information as Part of a JSON Search Index
- 24.3 Data-Guide Formats and Ways of Creating a Data Guide
- 24.4 JSON Data-Guide Fields
- 24.5 Data-Dictionary Views For Persistent Data-Guide Information
- 24.6 Specifying a Preferred Name for a Field Column
- 24.7 Creating a View Over JSON Data Based on Data-Guide Information
- 24.8 Adding and Dropping Virtual Columns For JSON Fields Based on Data-Guide Information
- 24.9 Change Triggers For Data Guide-Enabled Search Index
- 24.10 Multiple Data Guides Per Document Set
- 24.11 Querying a Data Guide
- 24.12 A Flat Data Guide For Purchase-Order Documents
- 24.13 A Hierarchical Data Guide For Purchase-Order Documents
- 24.14 A Schema Data Guide For Purchase-Order Documents
- Part V Generation of JSON Data
- Part VI PL/SQL Object Types for JSON
- Part VII GeoJSON Geographic Data
-
Part VIII Performance Tuning for JSON
- 29 Overview of Performance Tuning for JSON
-
30
Indexes for JSON Data
- 30.1 Overview of Indexing JSON Data
- 30.2 How To Tell Whether a Function-Based Index for JSON Data Is Picked Up
- 30.3 Creating Bitmap Indexes for JSON_VALUE
- 30.4 Creating B-Tree Indexes for JSON_VALUE
- 30.5 Using a JSON_VALUE Function-Based Index with JSON_TABLE Queries
- 30.6 Using a JSON_VALUE Function-Based Index with JSON_EXISTS Queries
- 30.7 Data Type Considerations for JSON_VALUE Indexing and Querying
- 30.8 Creating Multivalue Function-Based Indexes for JSON_EXISTS
- 30.9 Using a Multivalue Function-Based Index
- 30.10 Indexing Multiple JSON Fields Using a Composite B-Tree Index
- 30.11 JSON Search Index for Ad Hoc Queries and Full-Text Search
- 31 In-Memory JSON Data
- 32 JSON Query Rewrite To Use a Materialized View Over JSON_TABLE
- Appendixes
- Index