Table of Contents
- List of Examples
- 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
- 11 Simple Dot-Notation Access to JSON Data
- 12 SQL/JSON Path Expressions
- 13 Clauses Used in SQL/JSON Query Functions and Conditions
- 14 SQL/JSON Condition JSON_EXISTS
- 15 SQL/JSON Function JSON_VALUE
- 16 SQL/JSON Function JSON_QUERY
- 17 SQL/JSON Function JSON_TABLE
- 18
JSON Data Guide
- 18.1 Overview of JSON Data Guide
- 18.2 Persistent Data-Guide Information: Part of a JSON Search Index
- 18.3 Data-Guide Formats and Ways of Creating a Data Guide
- 18.4 JSON Data-Guide Fields
- 18.5 Specifying a Preferred Name for a Field Column
- 18.6 Creating a View Over JSON Data Based on Data-Guide Information
- 18.7 Adding and Dropping Virtual Columns For JSON Fields Based on Data-Guide Information
- 18.8 Change Triggers For Data Guide-Enabled Search Index
- 18.9 Multiple Data Guides Per Document Set
- 18.10 Querying a Data Guide
- 18.11 A Flat Data Guide For Purchase-Order Documents
- 18.12 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
- 23 Overview of Performance Tuning for JSON
- 24
Indexes for JSON Data
- 24.1 Overview of Indexing JSON Data
- 24.2 How To Tell Whether a Function-Based Index for JSON Data Is Picked Up
- 24.3 Creating Bitmap Indexes for SQL/JSON Condition JSON_EXISTS
- 24.4 Creating JSON_VALUE Function-Based Indexes
- 24.5 Using a JSON_VALUE Function-Based Index with JSON_TABLE Queries
- 24.6 Using a JSON_VALUE Function-Based Index with JSON_EXISTS Queries
- 24.7 Data Type Considerations for JSON_VALUE Indexing and Querying
- 24.8 Indexing Multiple JSON Fields Using a Composite B-Tree Index
- 24.9 JSON Search Index: Ad Hoc Queries and Full-Text Search
- 25 In-Memory JSON Data
- A Oracle Database JSON Restrictions
- B Diagrams for Basic SQL/JSON Path Expression Syntax
- Index