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  Y  

---

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 C
• 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
• aggregate item method 15.3
• ALL_JSON_COLUMNS view 4.1
• ALL_JSON_DATAGUIDE_FIELDS view 22.5
• ALL_JSON_DATAGUIDES view 22.5
• ALLOW SCALARS keywords, json_query RETURNING clause 16.1
• array, JSON 1.2
• array element, JSON 1.2
• array index 15.2.1
• array range specification 15.2.1
• array step, SQL/JSON path expressions 15.2.1
  • syntax C
• ASCII keyword
  • json_serialize function 2.3.3
• ASCII keyword, SQL functions 16.1
• avg() item method, SQL/JSON path expressions 15.3

---

B

• basic SQL/JSON path expression 15.2.1
  • BNF description C
  • diagrams C
• bind variable, passing a value to a SQL/JSON variable 15.2.1
• BNF syntax descriptions, basic SQL/JSON path expression C
• boolean() item method, SQL/JSON path expressions 15.3
• Boolean JSON value
  • generating 23.2
  • targeted by json_value 18.1
  • using FORMAT JSON to set 11
• booleanOnly() item method, SQL/JSON path expressions 15.3

---

C

• canonical form of a JSON number 16.1
• capabilities specification, Oracle Database support for JSON B
• 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 20.2
• client, using to retrieve JSON LOB data 7
• column, JSON 4
• COLUMNS clause
  • json_table 20.2
• columns of JSON data 2.2.2
• compare predicate, SQL/JSON path expressions
  • syntax C
• comparison, SQL/JSON path expressions
  • syntax C
• comparison filter predicates, SQL/JSON path expressions 15.2.1
• comparison in SQL/JSON path expression, types 15.4
• compatibility of data types, item methods 15.3
• composite multivalue function-based index 28.8, 28.9
• condition, SQL/JSON path expressions
  • syntax C
• condition (filter), SQL/JSON path expressions 15.2.1
• conditions, Oracle SQL
  • json_equal IV
  • json_textcontains 21.1
• conditions, SQL/JSON
  • is json 5
    • and JSON null 1.2
  • is not json 5
    • and JSON null 1.2
  • json_exists 17
    • indexing 28.3, 28.8, 28.9
• conjunction, SQL/JSON path expressions
  • syntax C
• constructor, JSON 2.3.4
  • JSON generation 23.1
• constructor, JSON data type 2.3.1
• context item, SQL/JSON path expressions 15.2.1
• count() item method, SQL/JSON path expressions 15.3
• 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 formats, ISO 8601 A
• 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
• DBMS_JSON.get_view_sql PL/SQL procedure 22.7
• 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 C
• DISALLOW SCALARS keywords
  • json_query 19
  • json_table 20.2
• DISALLOW SCALARS keywords, json_query RETURNING clause 16.1
• disjunction, SQL/JSON path expressions
  • syntax C
• 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
• ds_iso_format ISO 8601 duration format A
• dsInterval() item method, SQL/JSON path expressions 15.3
• duplicate field names in JSON objects 5.1
• duration formats, ISO 8601 A

---

E

• element of a JSON array 1.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 16.5
• exists filter predicate, SQL/JSON path expressions 15.2.1
• EXISTS keyword, json_table 20.2
• EXTENDED keyword
  • json_serialize function 2.3.3
  • JSON constructor 2.3.1
• extended object representation of JSON scalars 2.3.5
• EXTRA DATA clause, ON MISMATCH clause 16.5

---

F

• facet search of JSON data 21.2
• field, JSON object 1.2
• field name, SQL/JSON path expressions
  • syntax C
• filter, SQL/JSON path expressions 15.2.1
  • syntax C
• filter condition, SQL/JSON path expressions 15.2.1
• filter expression, SQL/JSON path expressions 15.2.1
• float() item method, SQL/JSON path expressions 15.3
• 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 20.2
  • SQL/JSON generation functions 23.1, 23.2
• FOR ORDINALITY keywords, json_table 20.2
• full-text search of JSON data 21, 21.1
• function-based indexing
  • multivalue 28.8, 28.9
• functions, Oracle SQL
  • json_dataguide 22.3, 22.4
    • as an aggregate function 22.10
    • hierarchical format 22.8.1, 22.13
    • pretty-print format 22.13
  • json_mergepatch 10
  • json_scalar 2.3.2, 2.3.4
  • json_serialize 2.3.3, 2.3.4
  • 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 C

---

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
• get_view_sql, DBMS_JSON PL/SQL procedure 22.7
• 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 16.5
• IM column store 29.1
• index, array 15.2.1
• indexing JSON data 28
  • composite B-tree index for multiple fields 28.10
  • for json_exists queries 28.6, 28.8, 28.9
  • for json_table queries 28.5
  • for search 28.11
  • full-text and numeric-range 28.11
  • 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, 28.8, 28.9
  • 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
  • multivalue function-based index 28.8
  • spatial 26
• in filter predicate, SQL/JSON path expressions 15.2.1
• 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 1.2
  • indexing 28.1
  • STRICT keyword 5.3
• is not json SQL/JSON condition 5
  • and JSON null 1.2
  • indexing 28.1
  • STRICT keyword 5.3
• ISO 8601 formats A
• item method
  • use with dot-notation syntax 14
• item method, SQL/JSON path expressions 15.2.1, 15.3
  • data type compatibility 15.3
  • implicit "only" method application 20.2
  • syntax C
• items data-guide field (JSON Schema keyword) 22.4

---

J

• JavaScript array 1.2
• JavaScript notation compared with JSON 1.1
• JavaScript object 1.2
• JavaScript object literal 1.2
• JavaScript Object Notation (JSON) 1.1
• JSON 1.1
  • character encoding 6
  • character-set conversion 6
  • compared with JavaScript notation 1.1
  • compared with XML 1.3
  • overview 1, 2
  • support by Oracle Database, specifications B
  • syntax 1, 1.2, 2
    • basic path expression 15.2.1, C
    • 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 Oracle SQL function 22.3, 22.4
  • as an aggregate function 22.10
  • hierarchical format 22.8.1, 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, 28.8, 28.9
• JSON_KEY_LIST PL/SQL object type 24
• json_mergepatch Oracle 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_scalar Oracle SQL function 2.3.2, 2.3.4
• json_serialize Oracle SQL function 2.3.3, 2.3.4
• json_table SQL/JSON function 20
  • DISALLOW SCALARS keywords 20.2
  • EXISTS keyword 20.2
  • 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, 20.2
  • TRUNCATE keyword 20.2
• json_textcontains Oracle SQL condition 21.1
• json_transform Oracle 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, extended objects 2.3.5
• JSON column 4
• JSON columns 2.2.2
• JSON data guide 22
  • overview 22.1
• JSON data type (SQL) 2.2.1
• JSON generation functions 23
• JSON language, Oracle-specific scalar types 1.2
• JSON LOB data 7
• JSON object types, PL/SQL
  • overview 24
• JSON scalars, object representation 2.3.5
• JSON scalar types, Oracle extended 2.2.1
• JSON Schema 22
  • keywords 22.4
• JSON search index 28.11
• JSON type constructor 2.3.1, 2.3.4
  • JSON generation 23.1
• JSON type data, migration from textual JSON data 2.3.6

---

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 B
• loading JSON data into the database 10
• 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
• maxNumber() item method, SQL/JSON path expressions 15.3
• maxString() item method, SQL/JSON path expressions 15.3
• migration of textual JSON data to JSON type data 2.3.6
• minNumber() item method, SQL/JSON path expressions 15.3
• minString() item method, SQL/JSON path expressions 15.3
• MISSING DATA clause, ON MISMATCH clause 16.5
• multiple data guides for the same JSON column 22.10
• multivalue function-based index 28.8, 28.9

---

N

• NESTED clause, instead of json_table 20.1
• NESTED PATH clause, json_table 20.4
• NoSQL databases 2.2
• 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 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.11

---

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
• o:sample_size data-guide field 22.4
• object, Javascript and JSON 1.2
• object literal, Javascript 1.2
• object member, JSON 1.2
• objects representation of JSON scalars 2.3.5
• object step, SQL/JSON path expressions 15.2.1
  • syntax C
• ON EMPTY clause, SQL/JSON query functions 16.4
• oneOf data-guide field (JSON Schema keyword) 22.4
• ON MISMATCH clause 16.5
• Oracle scalar types for JSON language 1.2
• Oracle SQL conditions IV
  • See also: SQL/JSON conditions
  • json_equal IV
  • json_textcontains 21.1
• Oracle SQL functions IV
  • See also: SQL/JSON functions
  • json_dataguide 22.3, 22.4
    • as an aggregate function 22.10
    • hierarchical format 22.8.1, 22.13
    • pretty-print format 22.13
  • json_mergepatch 10
  • json_scalar 2.3.2, 2.3.4
  • json_serialize 2.3.3, 2.3.4
  • json_transform 10
• Oracle support for JSON in the database 2.4
  • specifications B
• OSON binary JSON data format 2.2.1

---

P

• parent COLUMNS clause, json_table 20.2
• parsing of JSON data to PL/SQL object types 24
• PASSING clause, json_exists 17
• PATH clause
  • json_table 20.2
• PATH clause, json_table 20
• path expression, SQL/JSON 15, 15.1
  • comparison, types 15.4
  • for a json_table column 20.2
  • item methods 15.3
  • syntax 15.2, C
• path expression, SQL/JSON, for json_exists 17
• path expression, SQL/JSON, for json_query 18, 19
• path expression, SQL/JSON, for json_table rows 20
• performance tuning 27
• PL/SQL, use of JSON data 2.2.4
• PL/SQL functions
  • DBMS_JSON.get_index_dataguide 22.3, 22.4, 22.7.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.get_view_sql 22.7
  • DBMS_JSON.rename_column 22.4
• predicate
  • See: filter expression
• PRETTY, package DBMS_JSON 22.7.1, 22.12, 22.13
• PRETTY keyword
  • json_serialize function 2.3.3
• PRETTY keyword, SQL functions 16.1
• pretty-printing
  • in book examples
• pretty-printing serialized JSON data 2.3.3
• 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 7
• relational database with JSON data 2.2
• relative path expression 15.2.1
  • syntax C
• rename_column, DBMS_JSON PL/SQL procedure 22.4
• rendering of JSON data 16.1
• restrictions, Oracle Database support for JSON B
• 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 C
• scalar types and values, JSON 1.2
  • object representation 2.3.5
• schema, JSON 22
• schemaless database data 2.2
• SDO_GEOMETRY 26
• searching JSON data 21
  • facets 21.2
  • full-text 21.1
• 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 2.3.3
• setting values in PL/SQL object types 24
• sharding, data-guide information in index 22.2
• sibling COLUMNS clauses, json_table 20.2
• simple dot-notation access to JSON data 14
  • use with json_table SQL/JSON function 20
• Simple Oracle Document Access (SODA) 2
• simplified syntax
  • See: simple dot-notation access to JSON data
• size() item method, SQL/JSON path expressions 15.3
• SODA 2
• spatial JSON data 26
• specifications, Oracle Database support for JSON B
• SQL, overview of use with JSON data 2.2.3
• SQL/JSON conditions IV
  • See also: Oracle SQL conditions
  • is (not) json 5
  • is json
    • and JSON null 1.2
    • indexing 28.1
  • is not json
    • and JSON null 1.2
    • indexing 28.1
  • json_exists 17
    • as json_table 17.2
    • indexing 28.1, 28.3, 28.8, 28.9
• SQL/JSON functions IV
  • See also: Oracle SQL 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.4
  • for a json_table column 20.2
  • item methods 15.3
  • syntax 15.2
    • array step C
    • basic 15.2.1, C
    • compare predicate C
    • comparison C
    • condition C
    • conjunction C
    • disjunction C
    • field name C
    • filter C
    • function step C
    • item method C
    • object step C
    • relaxed 15.2.2
    • scalar C
    • variable C
• SQL/JSON path expression, for json_exists 17
• SQL/JSON path expression, for json_query 18, 19
• SQL/JSON path expression, for json_table rows 20
• 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.8.1, 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
• sum() item method, SQL/JSON path expressions 15.3
• support for JSON, Oracle Database 2.4
  • specifications B
• syntax diagrams, basic SQL/JSON path expression C

---

T

• tables with JSON data 2.2.2
• textual JSON data, migration to JSON type data 2.3.6
• textual SQL data types for JSON data 2.2.1
• time formats, ISO 8601 A
• 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
  • json_serialize function 2.3.3
  • json_table 20.2
• TRUNCATE keyword, Oracle extension for SQL/JSON 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 16.5
• types in path-expression comparisons 15.4

---

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 language 1.2
• variable, SQL/JSON path expressions 15.2.1
  • syntax C
• 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
  • 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 1.3
  • DOM 24

---

Y

• ym_iso_format ISO 8601 duration format A
• ymInterval() item method, SQL/JSON path expressions 15.3