Index

Symbols  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  

---

Symbols

• != comparison filter predicate, SQL/JSON path expressions 15.2.1
• ! filter predicate, SQL/JSON path expressions 15.2.1
• $, SQL/JSON path expressions
  • for a SQL/JSON variable 15.2.1
  • for the context item 15.2.1
• && filter predicate, SQL/JSON path expressions 15.2.1
• <= comparison filter predicate, SQL/JSON path expressions 15.2.1
• <> comparison filter predicate, SQL/JSON path expressions 15.2.1
• < comparison filter predicate, SQL/JSON path expressions 15.2.1
• == comparison filter predicate, SQL/JSON path expressions 15.2.1
• >= comparison filter predicate, SQL/JSON path expressions 15.2.1
• > comparison filter predicate, SQL/JSON path expressions 15.2.1
• || filter predicate, SQL/JSON path expressions 15.2.1

---

A

• abs() item method, SQL/JSON path expressions 15.3
• ABSENT ON NULL, SQL/JSON generation functions 23.1
• absolute path expression 15.2.1
  • syntax B
• add_vc trigger procedure 22.9
• add_virtual_columns, DBMS_JSON PL/SQL procedure 22.8, 22.8.1, 22.8.2
• adding virtual columns for JSON fields 22.8
  • based on a data guide-enabled search index 22.8.2
  • based on a hierarchical data guide 22.8.1
• ad hoc search of JSON data 28.9
• ALL_JSON_COLUMNS view 4.1
• ALL_JSON_DATAGUIDE_FIELDS view 22.5
• ALL_JSON_DATAGUIDES view 22.5
• array, JSON 2.2
• array element, JSON 2.2
• array index 15.2.1
• array range specification 15.2.1
• array step, SQL/JSON path expressions 15.2.1
  • syntax B
• ASCII keyword, SQL functions 16.1

---

B

• basic SQL/JSON path expression 15.2.1
  • BNF description B
  • diagrams B
• bind variable, passing a value to a SQL/JSON variable 15.2.1
• BLOB storage, using for JSON data 3
• BNF syntax descriptions, basic SQL/JSON path expression B
• boolean() item method, SQL/JSON path expressions 15.3
• booleanOnly() item method, SQL/JSON path expressions 15.3

---

C

• canonical form of a JSON number 16.1
• case-sensitivity
  • in data-guide field o:preferred_column_name 22.4
  • in query dot notation 14
  • in SQL/JSON path expression 15.2, 15.2.1
  • JSON and SQL
  • strict and lax JSON syntax 5.2
• ceiling() item method, SQL/JSON path expressions 15.3
• change trigger, data guide 22.9
  • user-defined 22.9.1
• character sets 6
• check constraint used to ensure well-formed JSON data 4
• child COLUMNS clause, json_table SQL/JSON function 20.2
• client, using to retrieve JSON Data 3
• client, using to retrieve JSON LOB data 7
• CLOB storage, using for JSON data 3
• COLUMNS clause, json_table SQL/JSON function 20.2
• columns of JSON data 1.1
• compare predicate, SQL/JSON path expressions
  • syntax B
• comparison, SQL/JSON path expressions
  • syntax B
• comparison filter predicates, SQL/JSON path expressions 15.2.1
• comparison in SQL/JSON path expression, types 15.5
• compatibility of data types, item methods 15.3
• condition, SQL/JSON path expressions
  • syntax B
• conditions, Oracle SQL
  • json_equal IV
• conditions, SQL/JSON
  • is json 5
    • and JSON null 2.2
  • is not json 5
    • and JSON null 2.2
  • json_exists 17
    • indexing 28.3
  • json_textcontains 28.9
• conjunction, SQL/JSON path expressions
  • syntax B
• context item, SQL/JSON path expressions 15.2.1
• create_view_on_path, DBMS_JSON PL/SQL procedure 22.7, 22.7.2
• create_view, DBMS_JSON PL/SQL procedure 22.7, 22.7.1

---

D

• data guide
  • change trigger 22.9
    • user-defined 22.9.1
  • fields 22.4
  • flat 22.12
  • hierarchical 22.13
  • multiple for the same JSON column 22.10
  • overview 22.1
• data types for JSON columns 3
• date() item method, SQL/JSON path expressions 15.3
• date and time formats, ISO 8601 15.4
• DBA_JSON_COLUMNS view 4.1
• DBA_JSON_DATAGUIDE_FIELDS view 22.5
• DBA_JSON_DATAGUIDES view 22.5
• DBMS_JSON.add_virtual_columns PL/SQL procedure 22.8, 22.8.1, 22.8.2
• DBMS_JSON.create_view_on_path PL/SQL procedure 22.7, 22.7.2
• DBMS_JSON.create_view PL/SQL procedure 22.7, 22.7.1
• DBMS_JSON.drop_virtual_columns PL/SQL procedure 22.8, 22.8.3
• DBMS_JSON.FORMAT_FLAT 22.3, 22.4, 22.12
• DBMS_JSON.FORMAT_HIERARCHICAL 22.3, 22.7.1, 22.8.1, 22.13
• DBMS_JSON.get_index_dataguide PL/SQL function 22.3, 22.4, 22.7.1, 22.8.1
• DBMS_JSON.PRETTY 22.7.1, 22.12, 22.13
• DBMS_JSON.rename_column PL/SQL procedure 22.4
• descendant step, SQL/JSON path expressions 15.2.1
• diagrams, basic SQL/JSON path expression syntax B
• disjunction, SQL/JSON path expressions
  • syntax B
• Document Object Model (DOM) 24
• DOM-like manipulation of JSON data 24
• dot-notation access to JSON data 14
  • use with json_table SQL/JSON function 20
• double() item method, SQL/JSON path expressions 15.3
• drop_virtual_columns, DBMS_JSON PL/SQL procedure 22.8, 22.8.3
• dropping virtual columns for JSON fields 22.8, 22.8.3
• duplicate field names in JSON objects 5.1

---

E

• element of a JSON array 2.2
• eq_regex filter predicate, SQL/JSON path expressions 15.2.1
• error clause, SQL query functions and conditions 16.3
• ERROR ON MISMATCH clause, json_value 16.5
• exists filter predicate, SQL/JSON path expressions 15.2.1
• EXISTS keyword, json_table SQL/JSON function 20
• EXTRA DATA clause, ON MISMATCH clause, json_value 16.5

---

F

• field, JSON object 2.2
• field name, SQL/JSON path expressions
  • syntax B
• filter, SQL/JSON path expressions
  • syntax B
• filter condition, SQL/JSON path expressions 15.2.1
• filter expression, SQL/JSON path expressions 15.2.1
• floor() item method, SQL/JSON path expressions 15.3
• FORMAT_FLAT, package DBMS_JSON 22.3, 22.4, 22.12
• FORMAT_HIERARCHICAL, package DBMS_JSON 22.3, 22.7.1, 22.8.1, 22.13
• FORMAT JSON keywords
  • json_table SQL/JSON function 20.2
  • SQL/JSON generation functions 23.1, 23.2
• FOR ORDINALITY keywords, json_table SQL/JSON function 20
• full-text search of JSON data 28.9
• functions, Oracle SQL
  • json_serialize 21
• functions, SQL
  • json_dataguide 22.3, 22.4
    • as an aggregate function 22.10
    • hierarchical format 22.13
    • pretty-print format 22.13
  • json_mergepatch 10
  • json_transform 10
• functions, SQL/JSON
  • json_array 23.4
  • json_arrayagg 23.6
  • json_object 23.3
  • json_objectagg 23.5
  • json_query 19
  • json_table 20
  • json_value 18
    • function-based indexing 28.4
    • indexing for geographic data 26
    • null JSON value 18.2
    • returning an object-type instance 18.3
• function step, SQL/JSON path expressions 15.2.1
  • syntax B

---

G

• generation of JSON data using SQL 23, 23.1
  • input SQL values 23.2
• geographic JSON data 26
• GeoJSON 26
• geometric features in JSON 26
• get_index_dataguide, DBMS_JSON PL/SQL function 22.3, 22.4, 22.7.1, 22.8.1
• get() method, PL/SQL object types 24

---

H

• has substring filter predicate, SQL/JSON path expressions 15.2.1
• hidden virtual columns projected from JSON data 22.8

---

I

• IGNORE ON MISMATCH clause, json_value 16.5
• IM column store 29.1
• index, array 15.2.1
• indexing JSON data 28
  • composite B-tree index for multiple fields 28.8
  • for json_exists queries 28.6
  • for json_table queries 28.5
  • for search 28.9
  • full-text and numeric-range 28.9
  • function-based 28.4
    • for geographic data 26
  • GeoJSON 26
  • is (not) json SQL/JSON condition 28.1
  • json_exists SQL/JSON condition 28.3
  • json_value SQL/JSON function 28.4
    • data type considerations 28.7
    • for geographic data 26
    • for json_exists queries 28.6
    • for json_table queries 28.5
  • spatial 26
• In-Memory Column Store 29.1
  • populating JSON into 29.2
  • upgrading tables with JSON data for 29.3
• inserting JSON data into a column 10
• introspection of PL/SQL object types 24
• is json SQL/JSON condition 5
  • and JSON null 2.2
  • indexing 28.1
  • STRICT keyword 5.3
• is not json SQL/JSON condition 5
  • and JSON null 2.2
  • indexing 28.1
  • STRICT keyword 5.3
• ISO 8601 date and time formats 15.4
• item method, SQL/JSON path expressions 15.2.1, 15.3
  • data type compatibility 15.3
  • syntax B
• items data-guide field (JSON Schema keyword) 22.4

---

J

• JavaScript array 2.2
• JavaScript notation compared with JSON 2.1
• JavaScript object 2.2
• JavaScript object literal 2.2
• JavaScript Object Notation (JSON) 2.1
• JSON 2.1
  • character encoding 6
  • character-set conversion 6
  • compared with JavaScript notation 2.1
  • compared with XML 2.3
  • overview 1, 2
  • support by Oracle Database, restrictions A
  • syntax 1, 2, 2.2
    • basic path expression 15.2.1, B
    • strict and lax 5.2
• JSON_ARRAY_T PL/SQL object type 24
• json_arrayagg SQL/JSON function 23.6
• json_array SQL/JSON function 23.4
• json_dataguide SQL function 22.3, 22.4
  • as an aggregate function 22.10
  • hierarchical format 22.13
  • pretty-print format 22.13
• JSON_ELEMENT_T PL/SQL object type 24
• json_equal Oracle SQL condition IV
• json_exists SQL/JSON condition 17
  • as json_table 17.2
  • indexing 28.1, 28.3, 28.6
• JSON_KEY_LIST PL/SQL object type 24
• json_mergepatch SQL function 10
• JSON_OBJECT_T PL/SQL object type 24
• json_objectagg SQL/JSON function 23.5
• json_object SQL/JSON function 23.3
• json_query SQL/JSON function 19
  • as json_table 19.1
• JSON_SCALAR_T PL/SQL object type 24
• json_serialize Oracle SQL function 21
• json_table SQL/JSON function 20
  • EXISTS keyword 20
  • FORMAT JSON keywords 20.2
  • generalizes other SQL/JSON functions and conditions 20.3
  • indexing for queries 28.5
  • NESTED PATH clause 20.4
  • PATH clause 20
• json_textcontains SQL/JSON condition 28.9
• json_transform SQL function 10
• json_value SQL/JSON function 18
  • as json_table 18.4
  • data type considerations for indexing 28.7
  • function-based indexing 28.4
    • for geographic data 26
  • indexing for json_exists queries 28.6
  • indexing for json_table queries 28.5
  • null JSON value 18.2
  • returning an object-type instance 18.3
• JSON columns 1.1
• JSON data guide 22
  • overview 22.1
• JSON generation functions 23
• JSON LOB data 7
• JSON object types, PL/SQL
  • overview 24
• JSON Schema 22
  • keywords 22.4
• JSON search index 28.9

---

K

• key, JSON object
  • See: field, JSON object
• keywords
  • JSON Schema 22.4

---

L

• lax JSON syntax 5.2
  • specifying 5.3
• length() item method, SQL/JSON path expressions 15.3
• like_regex filter predicate, SQL/JSON path expressions 15.2.1
• like filter predicate, SQL/JSON path expressions 15.2.1
• limitations, Oracle Database support for JSON A
• loading JSON data into the database 10
• LOB storage, using for JSON data 3
• LOB storage of JSON data 7
• lower() item method, SQL/JSON path expressions 15.3

---

M

• materialized view of JSON data 20.5
  • indexing 30
  • rewriting automatically 30
• MISSING DATA clause, ON MISMATCH clause, json_value 16.5
• multiple data guides for the same JSON column 22.10

---

N

• NESTED clause, instead of json_table 20.1
• NESTED PATH clause, json_table 20.4
• NoSQL databases 1.1
• null handling, SQL/JSON generation functions 23.1, 23.2
• NULL-handling clause, SQL/JSON generation functions 23.1
• NULL ON EMPTY clause, SQL/JSON query functions 16.4
• NULL ON MISMATCH clause, json_value 16.5
• NULL ON NULL, SQL/JSON generation functions 23.1
• number() item method, SQL/JSON path expressions 15.3
• numberOnly() item method, SQL/JSON path expressions 15.3
• numeric-range indexing 28.9

---

O

• o:frequency data-guide field 22.4
• o:hidden data-guide field 22.8
• o:high_value data-guide field 22.4
• o:last_analyzed data-guide field 22.4
• o:length data-guide field 22.4
• o:low_value data-guide field 22.4
• o:num_nulls data-guide field 22.4
• o:path data-guide field 22.4
• o:preferred_column_name data-guide field 22.4
• object, Javascript and JSON 2.2
• object literal, Javascript 2.2
• object member, JSON 2.2
• object step, SQL/JSON path expressions 15.2.1
  • syntax B
• ON EMPTY clause, SQL/JSON query functions 16.4
• oneOf data-guide field (JSON Schema keyword) 22.4
• ON MISMATCH clause, json_value 16.5
• Oracle SQL conditions IV
  • See also: SQL/JSON conditions
  • json_equal IV
• Oracle SQL functions
  • json_dataguide 22.3, 22.4
    • as an aggregate function 22.10
    • hierarchical format 22.13
    • pretty-print format 22.13
  • json_mergepatch 10
  • json_serialize 21
  • json_transform 10
• Oracle support for JSON in the database A

---

P

• parent COLUMNS clause, json_table SQL/JSON function 20.2
• parsing of JSON data to PL/SQL object types 24
• PASSING clause, json_exists 17
• PATH clause, json_table 20
• path expression, SQL/JSON 15, 15.1
  • comparison, types 15.5
  • item methods 15.3
  • syntax 15.2, B
• performance tuning 27
• PL/SQL functions
  • DBMS_JSON.get_index_dataguide 22.3, 22.4, 22.7.1, 22.8.1
• PL/SQL object-type methods 24
• PL/SQL object types
  • overview 24
• PL/SQL procedures
  • DBMS_JSON.add_virtual_columns 22.8, 22.8.1, 22.8.2
  • DBMS_JSON.create_view 22.7, 22.7.1
  • DBMS_JSON.create_view_on_path 22.7, 22.7.2
  • DBMS_JSON.drop_virtual_columns 22.8, 22.8.3
  • DBMS_JSON.rename_column 22.4
• PRETTY, package DBMS_JSON 22.7.1, 22.12, 22.13
• PRETTY keyword, SQL functions 16.1
• pretty-printing
  • in book examples
• projecting virtual columns from JSON fields 22.8
• properties data-guide field (JSON Schema keyword) 22.4
• property, JSON object
  • See: field, JSON object
• put() method, PL/SQL object types 24

---

Q

• queries, dot notation 14
  • use with json_table SQL/JSON function 20
• query rewrite to a materialized view 30

---

R

• range specification, array 15.2.1
• rawtohex SQL function, for insert or update with BLOB JSON column 3, 7
• relational database with JSON data 1.1
• relative path expression 15.2.1
  • syntax B
• rename_column, DBMS_JSON PL/SQL procedure 22.4
• rendering of JSON data 16.1
• restrictions, Oracle Database support for JSON A
• retrieval of JSON LOB data from database by client 7
• RETURNING clause
  • SQL/JSON generation functions 23.1
  • SQL query functions 16.1
• rewrite of JSON queries to a materialized view 30
• row source, JSON
  • definition 20

---

S

• scalar, SQL/JSON path expressions
  • syntax B
• scalar value, JSON 2.2
• schema, JSON 22
• schemaless database data 1.1
• SDO_GEOMETRY 26
• searching JSON data 28.9
• SELECT statement, NESTED clause instead of json_table 20.1
• serialization
  • of JSON data from queries 16.1
  • of JSON data in PL/SQL object types 24
• serializing JSON data 21
• setting values in PL/SQL object types 24
• sharding, data-guide information in index 22.2
• sibling COLUMNS clauses, json_table SQL/JSON function 20.2
• simple dot-notation access to JSON data 14
  • use with json_table SQL/JSON function 20
• Simple Oracle Document Access (SODA) 1
• simplified syntax
  • See: simple dot-notation access to JSON data
• size() item method, SQL/JSON path expressions 15.3
• SODA 1
• spatial JSON data 26
• SQL/JSON conditions IV
  • See also: Oracle SQL conditions
  • is (not) json 5
  • is json
    • and JSON null 2.2
    • indexing 28.1
  • is not json
    • and JSON null 2.2
    • indexing 28.1
  • json_exists 17
    • as json_table 17.2
    • indexing 28.1, 28.3
  • json_textcontains 28.9
• SQL/JSON functions
  • for generating JSON 23
  • json_array 23.4
  • json_arrayagg 23.6
  • json_object 23.3
  • json_objectagg 23.5
  • json_query 19
    • as json_table 19.1
  • json_table 20
  • json_value 18
    • as json_table 18.4
    • function-based indexing 26, 28.4
    • null JSON value 18.2
    • returning an object-type instance 18.3
• SQL/JSON generation functions 23, 23.1
  • input SQL values 23.2
• SQL/JSON path expression 15, 15.1
  • comparison, types 15.5
  • item methods 15.3
  • syntax 15.2
    • array step B
    • basic 15.2.1, B
    • compare predicate B
    • comparison B
    • condition B
    • conjunction B
    • disjunction B
    • field name B
    • filter B
    • function step B
    • item method B
    • object step B
    • relaxed 15.2.2
    • scalar B
    • variable B
• SQL/JSON query functions
  • WITH WRAPPER keywords 16.2
• SQL/JSON variable 15.2.1
• SQL functions
  • json_dataguide 22.3, 22.4
    • as an aggregate function 22.10
    • hierarchical format 22.13
    • pretty-print format 22.13
  • json_mergepatch 10
  • json_transform 10
• SQL NESTED clause, instead of json_table 20.1
• starts with filter predicate, SQL/JSON path expressions 15.2.1
• step, SQL/JSON path expressions 15.2.1
• storing and managing JSON data, overview 3
• strict JSON syntax 5.2
  • specifying 5.3
• STRICT keyword
  • is (not) json SQL/JSON condition 5.3
  • SQL/JSON generation functions 23.1
• string() item method, SQL/JSON path expressions 15.3
• stringOnly() item method, SQL/JSON path expressions 15.3
• support for JSON, Oracle Database A
• syntax diagrams, basic SQL/JSON path expression B

---

T

• tables with JSON data 1.1
• time and date formats, ISO 8601 15.4
• timestamp() item method, SQL/JSON path expressions 15.3
• tree-like representation of JSON data 24
• trigger for data-guide changes 22.9
• TRUNCATE keyword, Oracle extension for SQL/JSON VARCHAR2 return value 20
• TRUNCATE keyword, Oracle extension for SQL VARCHAR2 return value 16.1
• type() item method, SQL/JSON path expressions 15.3
• type data-guide field (JSON Schema keyword) 22.4
• TYPE ERROR clause, ON MISMATCH clause, json_value 16.5

---

U

• UNCONDITIONAL keyword, SQL/JSON query functions 16.2
• unique field names in JSON objects 5.1
• updating JSON data 10
• upper() item method, SQL/JSON path expressions 15.3
• USER_JSON_COLUMNS view 4.1
• USER_JSON_DATAGUIDE_FIELDS view 22.5
• USER_JSON_DATAGUIDES view 22.5
• user-defined data-guide change trigger 22.9.1

---

V

• value, JSON 2.2
• variable, SQL/JSON path expressions 15.2.1
  • syntax B
• view
  • create based on a data guide 22.7.1
  • create based on data guide-enabled index and a path 22.7.2
  • create using SQL/JSON function json_table 20.5
• views
  • ALL_JSON_COLUMNS 4.1
  • ALL_JSON_DATAGUIDE_FIELDS 22.5
  • ALL_JSON_DATAGUIDES 22.5
  • DBA_JSON_COLUMNS 4.1
  • DBA_JSON_DATAGUIDE_FIELDS 22.5
  • DBA_JSON_DATAGUIDES 22.5
  • USER_JSON_COLUMNS 4.1
  • USER_JSON_DATAGUIDE_FIELDS 22.5
  • USER_JSON_DATAGUIDES 22.5
• virtual columns for JSON fields, adding 22.8
  • based on a data guide-enabled search index 22.8.2
  • based on a hierarchical data guide 22.8.1

---

W

• well formed JSON data 5
• well-formed JSON data
  • ensuring 3
• WITHOUT UNIQUE KEYS keywords, JSON condition is json 5.1
• WITH UNIQUE KEYS keywords, JSON condition is json 5.1
• WITH WRAPPER keywords, SQL/JSON query functions 16.2
• wrapper clause, SQL/JSON query functions 16.2
• WRAPPER keyword, SQL/JSON query functions 16.2

---

X

• XML
  • compared with JSON 2.3
  • DOM 24