Table of Contents
- List of Examples
- List of Figures
- List of Tables
- Title and Copyright Information
- Preface
- Changes in This Release for Oracle Database JSON Developer's Guide
- Part I Introduction to JSON Data and Oracle Database
- Part II Store and Manage JSON Data
- Part III Insert, Update, and Load JSON Data
-
Part IV Query JSON Data
- 13 Simple Dot-Notation Access to JSON Data
- 14 SQL/JSON Path Expressions
- 15 Clauses Used in SQL Query Functions and Conditions
- 16 SQL/JSON Condition JSON_EXISTS
- 17 SQL/JSON Function JSON_VALUE
- 18 SQL/JSON Function JSON_QUERY
- 19 SQL/JSON Function JSON_TABLE
- 20 Oracle SQL Function JSON_SERIALIZE
-
21
JSON Data Guide
- 21.1 Overview of JSON Data Guide
- 21.2 Persistent Data-Guide Information: Part of a JSON Search Index
- 21.3 Data-Guide Formats and Ways of Creating a Data Guide
- 21.4 JSON Data-Guide Fields
- 21.5 Data-Dictionary Views For Persistent Data-Guide Information
- 21.6 Specifying a Preferred Name for a Field Column
- 21.7 Creating a View Over JSON Data Based on Data-Guide Information
- 21.8 Adding and Dropping Virtual Columns For JSON Fields Based on Data-Guide Information
- 21.9 Change Triggers For Data Guide-Enabled Search Index
- 21.10 Multiple Data Guides Per Document Set
- 21.11 Querying a Data Guide
- 21.12 A Flat Data Guide For Purchase-Order Documents
- 21.13 A Hierarchical 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
- 26 Overview of Performance Tuning for JSON
-
27
Indexes for JSON Data
- 27.1 Overview of Indexing JSON Data
- 27.2 How To Tell Whether a Function-Based Index for JSON Data Is Picked Up
- 27.3 Creating Bitmap Indexes for SQL/JSON Condition JSON_EXISTS
- 27.4 Creating JSON_VALUE Function-Based Indexes
- 27.5 Using a JSON_VALUE Function-Based Index with JSON_TABLE Queries
- 27.6 Using a JSON_VALUE Function-Based Index with JSON_EXISTS Queries
- 27.7 Data Type Considerations for JSON_VALUE Indexing and Querying
- 27.8 Indexing Multiple JSON Fields Using a Composite B-Tree Index
- 27.9 JSON Search Index: Ad Hoc Queries and Full-Text Search
- 28 In-Memory JSON Data
- 29 JSON Query Rewrite To Use a Materialized View Over JSON_TABLE
- A Oracle Database JSON Restrictions
- B Diagrams for Basic SQL/JSON Path Expression Syntax
- Index