1. Index

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 13.2.1
  • ! filter predicate, SQL/JSON path expressions 13.2.1
  • $, SQL/JSON path expressions
    • for a SQL/JSON variable 13.2.1
    • for the context item 13.2.1
  • && filter predicate, SQL/JSON path expressions 13.2.1
  • <= comparison filter predicate, SQL/JSON path expressions 13.2.1
  • <> comparison filter predicate, SQL/JSON path expressions 13.2.1
  • < comparison filter predicate, SQL/JSON path expressions 13.2.1
  • == comparison filter predicate, SQL/JSON path expressions 13.2.1
  • >= comparison filter predicate, SQL/JSON path expressions 13.2.1
  • > comparison filter predicate, SQL/JSON path expressions 13.2.1
  • || filter predicate, SQL/JSON path expressions 13.2.1

A

  • abs() item method, SQL/JSON path expressions 13.3
  • ABSENT ON NULL, SQL/JSON generation functions 21.1
  • absolute path expression 13.2.1
    • syntax B
  • add_vc trigger procedure 20.9
  • add_virtual_columns, DBMS_JSON PL/SQL procedure 20.8, 20.8.1, 20.8.2
  • adding virtual columns for JSON fields 20.8
    • based on a data guide-enabled search index 20.8.2
    • based on a hierarchical data guide 20.8.1
  • ad hoc search of JSON data 26.9
  • ALL_JSON_COLUMNS view 4.1
  • ALL_JSON_DATAGUIDE_FIELDS view 20.5
  • ALL_JSON_DATAGUIDES view 20.5
  • array, JSON 2.2
  • array element, JSON 2.2
  • array index 13.2.1
  • array range specification 13.2.1
  • array step, SQL/JSON path expressions 13.2.1
    • syntax B
  • ASCII keyword, SQL functions 14.1

B

  • basic SQL/JSON path expression 13.2.1
    • BNF description B
    • diagrams B
  • BNF syntax descriptions, basic SQL/JSON path expression B
  • boolean() item method, SQL/JSON path expressions 13.3
  • booleanOnly() item method, SQL/JSON path expressions 13.3

C

  • canonical form of a JSON number 14.1
  • case-sensitivity
    • in data-guide field o:preferred_column_name 20.4
    • in query dot notation 12
    • in SQL/JSON path expression 13.2, 13.2.1
    • JSON and SQL
    • strict and lax JSON syntax 5.2
  • ceiling() item method, SQL/JSON path expressions 13.3
  • change trigger, data guide 20.9
  • character sets 6
  • check constraint used to ensure well-formed JSON data 4
  • child COLUMNS clause, json_table SQL/JSON function 18.2
  • COLUMNS clause, json_table SQL/JSON function 18.2
  • compare predicate, SQL/JSON path expressions
    • syntax B
  • comparison, SQL/JSON path expressions
    • syntax B
  • comparison filter predicates, SQL/JSON path expressions 13.2.1
  • comparison in SQL/JSON path expression, types 13.5
  • compatibility of data types, item methods 13.3
  • condition, SQL/JSON path expressions
    • syntax B
  • conditions, Oracle SQL
    • json_equal
  • conditions, SQL/JSON
    • is json 5
      • and JSON null 2.2
    • is not json 5
      • and JSON null 2.2
    • json_exists 15
    • json_textcontains 26.9
  • conjunction, SQL/JSON path expressions
    • syntax B
  • context item, SQL/JSON path expressions 13.2.1
  • create_view_on_path, DBMS_JSON PL/SQL procedure 20.7, 20.7.2
  • create_view, DBMS_JSON PL/SQL procedure 20.7, 20.7.1

D

  • data guide
  • date() item method, SQL/JSON path expressions 13.3
  • date and time formats, ISO 8601 13.4
  • DBA_JSON_COLUMNS view 4.1
  • DBA_JSON_DATAGUIDE_FIELDS view 20.5
  • DBA_JSON_DATAGUIDES view 20.5
  • DBMS_JSON.add_virtual_columns PL/SQL procedure 20.8, 20.8.1, 20.8.2
  • DBMS_JSON.create_view_on_path PL/SQL procedure 20.7, 20.7.2
  • DBMS_JSON.create_view PL/SQL procedure 20.7, 20.7.1
  • DBMS_JSON.drop_virtual_columns PL/SQL procedure 20.8, 20.8.3
  • DBMS_JSON.FORMAT_FLAT 20.3, 20.4, 20.12
  • DBMS_JSON.FORMAT_HIERARCHICAL 20.3, 20.7.1, 20.8.1, 20.13
  • DBMS_JSON.get_index_dataguide PL/SQL function 20.3, 20.4, 20.7.1, 20.8.1
  • DBMS_JSON.PRETTY 20.7.1, 20.12, 20.13
  • DBMS_JSON.rename_column PL/SQL procedure 20.4
  • descendant step, SQL/JSON path expressions 13.2.1
  • diagrams, basic SQL/JSON path expression syntax B
  • disjunction, SQL/JSON path expressions
    • syntax B
  • Document Object Model (DOM) 22
  • DOM-like manipulation of JSON data 22
  • dot-notation access to JSON data 12
    • use with json_table SQL/JSON function 18
  • double() item method, SQL/JSON path expressions 13.3
  • drop_virtual_columns, DBMS_JSON PL/SQL procedure 20.8, 20.8.3
  • dropping virtual columns for JSON fields 20.8, 20.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 13.2.1
  • error clause, SQL query functions and conditions 14.3
  • ERROR ON MISMATCH clause, json_value 14.5
  • exists filter predicate, SQL/JSON path expressions 13.2.1
  • EXISTS keyword, json_table SQL/JSON function 18
  • EXTRA DATA clause, ON MISMATCH clause, json_value 14.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 13.2.1
  • filter expression, SQL/JSON path expressions 13.2.1
  • floor() item method, SQL/JSON path expressions 13.3
  • FORMAT_FLAT, package DBMS_JSON 20.3, 20.4, 20.12
  • FORMAT_HIERARCHICAL, package DBMS_JSON 20.3, 20.7.1, 20.8.1, 20.13
  • FORMAT JSON keywords
    • json_table SQL/JSON function 18.2
    • SQL/JSON generation functions 21.1, 21.2
  • FOR ORDINALITY keywords, json_table SQL/JSON function 18
  • full-text search of JSON data 26.9
  • functions, Oracle SQL
    • json_serialize 19
  • functions, SQL
    • json_dataguide 20.3, 20.4
      • as an aggregate function 20.10
      • hierarchical format 20.13
      • pretty-print format 20.13
    • json_mergepatch 9
  • functions, SQL/JSON
    • json_array 21.4
    • json_arrayagg 21.6
    • json_object 21.3
    • json_objectagg 21.5
    • json_query 17
    • json_table 18
    • json_value 16
      • function-based indexing 26.4
      • indexing for geographic data 24
      • null JSON value 16.2
      • returning an object-type instance 16.3
  • function step, SQL/JSON path expressions 13.2.1
    • syntax B

G

  • generation of JSON data using SQL 21, 21.1
    • input SQL values 21.2
  • geographic JSON data 24
  • GeoJSON 24
  • geometric features in JSON 24
  • get_index_dataguide, DBMS_JSON PL/SQL function 20.3, 20.4, 20.7.1, 20.8.1
  • get() method, PL/SQL object types 22

H

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

I

  • IGNORE ON MISMATCH clause, json_value 14.5
  • IM column store 27.1
  • index, array 13.2.1
  • indexing JSON data 26
    • composite B-tree index for multiple fields 26.8
    • for json_exists queries 26.6
    • for json_table queries 26.5
    • for search 26.9
    • full-text and numeric-range 26.9
    • function-based 26.4
      • for geographic data 24
    • GeoJSON 24
    • is (not) json SQL/JSON condition 26.1
    • json_exists SQL/JSON condition 26.3
    • json_value SQL/JSON function 26.4
      • data type considerations 26.7
      • for geographic data 24
      • for json_exists queries 26.6
      • for json_table queries 26.5
    • spatial 24
  • In-Memory Column Store 27.1
    • populating JSON into 27.2
    • upgrading tables with JSON data for 27.3
  • inserting JSON data into a column 9
  • introspection of PL/SQL object types 22
  • is json SQL/JSON condition 5
    • and JSON null 2.2
    • indexing 26.1
    • STRICT keyword 5.3
  • is not json SQL/JSON condition 5
    • and JSON null 2.2
    • indexing 26.1
    • STRICT keyword 5.3
  • ISO 8601 date and time formats 13.4
  • item method, SQL/JSON path expressions 13.2.1, 13.3
    • data type compatibility 13.3
    • syntax B
  • items data-guide field (JSON Schema keyword) 20.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 13.2.1, B
      • strict and lax 5.2
  • JSON_ARRAY_T PL/SQL object type 22
  • json_arrayagg SQL/JSON function 21.6
  • json_array SQL/JSON function 21.4
  • json_dataguide SQL function 20.3, 20.4
    • as an aggregate function 20.10
    • hierarchical format 20.13
    • pretty-print format 20.13
  • JSON_ELEMENT_T PL/SQL object type 22
  • json_equal Oracle SQL condition
  • json_exists SQL/JSON condition 15
  • JSON_KEY_LIST PL/SQL object type 22
  • json_mergepatch() PL/SQL object-type method 9
  • json_mergepatch SQL function 9
  • JSON_OBJECT_T PL/SQL object type 22
  • json_objectagg SQL/JSON function 21.5
  • json_object SQL/JSON function 21.3
  • json_query SQL/JSON function 17
    • as json_table 17.1
  • JSON_SCALAR_T PL/SQL object type 22
  • json_serialize Oracle SQL function 19
  • json_table SQL/JSON function 18
    • EXISTS keyword 18
    • FORMAT JSON keywords 18.2
    • generalizes other SQL/JSON functions and conditions 18.3
    • indexing for queries 26.5
    • NESTED PATH clause 18.4
    • PATH clause 18
  • json_textcontains SQL/JSON condition 26.9
  • json_value SQL/JSON function 16
    • as json_table 16.4
    • data type considerations for indexing 26.7
    • function-based indexing 26.4
      • for geographic data 24
    • indexing for json_exists queries 26.6
    • indexing for json_table queries 26.5
    • null JSON value 16.2
    • returning an object-type instance 16.3
  • JSON data guide 20
  • JSON generation functions 21
  • JSON object types, PL/SQL
    • overview 22
  • JSON Schema 20
  • JSON search index 26.9

K

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

L

  • lax JSON syntax 5.2
    • specifying 5.3
  • length() item method, SQL/JSON path expressions 13.3
  • like_regex filter predicate, SQL/JSON path expressions 13.2.1
  • like filter predicate, SQL/JSON path expressions 13.2.1
  • limitations, Oracle Database support for JSON A
  • loading JSON data into the database 9
  • lower() item method, SQL/JSON path expressions 13.3

M

  • materialized view of JSON data 18.5
  • MISSING DATA clause, ON MISMATCH clause, json_value 14.5
  • multiple data guides for the same JSON column 20.10

N

  • NESTED clause, instead of json_table 18.1
  • NESTED PATH clause, json_table 18.4
  • null handling, SQL/JSON generation functions 21.1, 21.2
  • NULL-handling clause, SQL/JSON generation functions 21.1
  • NULL ON EMPTY clause, SQL/JSON query functions 14.4
  • NULL ON MISMATCH clause, json_value 14.5
  • NULL ON NULL, SQL/JSON generation functions 21.1
  • number() item method, SQL/JSON path expressions 13.3
  • numberOnly() item method, SQL/JSON path expressions 13.3
  • numeric-range indexing 26.9

O

  • o:frequency data-guide field 20.4
  • o:hidden data-guide field 20.8
  • o:high_value data-guide field 20.4
  • o:last_analyzed data-guide field 20.4
  • o:length data-guide field 20.4
  • o:low_value data-guide field 20.4
  • o:num_nulls data-guide field 20.4
  • o:path data-guide field 20.4
  • o:preferred_column_name data-guide field 20.4
  • object, Javascript and JSON 2.2
  • object literal, Javascript 2.2
  • object member, JSON 2.2
  • object step, SQL/JSON path expressions 13.2.1
    • syntax B
  • ON EMPTY clause, SQL/JSON query functions 14.4
  • oneOf data-guide field (JSON Schema keyword) 20.4
  • ON MISMATCH clause, json_value 14.5
  • Oracle SQL conditions
    • See also: SQL/JSON conditions
    • json_equal
  • Oracle SQL functions
    • json_dataguide 20.3, 20.4
      • as an aggregate function 20.10
      • hierarchical format 20.13
      • pretty-print format 20.13
    • json_mergepatch 9
    • json_serialize 19
  • Oracle support for JSON in the database A

P

  • parent COLUMNS clause, json_table SQL/JSON function 18.2
  • parsing of JSON data to PL/SQL object types 22
  • PASSING clause, json_exists 15
  • PATH clause, json_table 18
  • path expression, SQL/JSON 13, 13.1
  • performance tuning 25
  • PL/SQL functions
  • PL/SQL object-type methods 22
    • json_mergepatch() 9
  • PL/SQL object types
    • overview 22
  • PL/SQL procedures
  • PRETTY, package DBMS_JSON 20.7.1, 20.12, 20.13
  • PRETTY keyword, SQL functions 14.1
  • pretty-printing
    • in book examples
  • projecting virtual columns from JSON fields 20.8
  • properties data-guide field (JSON Schema keyword) 20.4
  • property, JSON object
    • See: field, JSON object
  • put() method, PL/SQL object types 22

Q

  • queries, dot notation 12
    • use with json_table SQL/JSON function 18

R

  • range specification, array 13.2.1
  • rawtohex SQL function, for insert or update with BLOB JSON column 3
  • relative path expression 13.2.1
    • syntax B
  • rename_column, DBMS_JSON PL/SQL procedure 20.4
  • rendering of JSON data 14.1
  • restrictions, Oracle Database support for JSON A
  • RETURNING clause
    • SQL/JSON generation functions 21.1
    • SQL query functions 14.1
  • row source, JSON
    • definition 18

S

  • scalar, SQL/JSON path expressions
    • syntax B
  • scalar value, JSON 2.2
  • schema, JSON 20
  • SDO_GEOMETRY 24
  • searching JSON data 26.9
  • SELECT statement, NESTED clause instead of json_table 18.1
  • serialization
    • of JSON data from queries 14.1
    • of JSON data in PL/SQL object types 22
  • serializing JSON data 19
  • setting values in PL/SQL object types 22
  • sharding, data-guide information in index 20.2
  • sibling COLUMNS clauses, json_table SQL/JSON function 18.2
  • simple dot-notation access to JSON data 12
    • use with json_table SQL/JSON function 18
  • Simple Oracle Document Access (SODA) 1
  • simplified syntax
    • See: simple dot-notation access to JSON data
  • size() item method, SQL/JSON path expressions 13.3
  • SODA 1
  • spatial JSON data 24
  • SQL/JSON conditions
    • See also: Oracle SQL conditions
    • is (not) json 5
    • is json
    • is not json
    • json_exists 15
    • json_textcontains 26.9
  • SQL/JSON functions
    • for generating JSON 21
    • for querying 1.1
    • json_array 21.4
    • json_arrayagg 21.6
    • json_object 21.3
    • json_objectagg 21.5
    • json_query 17
      • as json_table 17.1
    • json_table 18
    • json_value 16
      • as json_table 16.4
      • function-based indexing 24, 26.4
      • null JSON value 16.2
      • returning an object-type instance 16.3
  • SQL/JSON generation functions 21, 21.1
    • input SQL values 21.2
  • SQL/JSON path expression 13, 13.1
    • comparison, types 13.5
    • item methods 13.3
    • syntax 13.2
      • array step B
      • basic 13.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 13.2.2
      • scalar B
      • variable B
  • SQL/JSON query functions 1.1
    • WITH WRAPPER keywords 14.2
  • SQL/JSON variable 13.2.1
  • SQL functions
    • json_dataguide 20.3, 20.4
      • as an aggregate function 20.10
      • hierarchical format 20.13
      • pretty-print format 20.13
    • json_mergepatch 9
  • SQL NESTED clause, instead of json_table 18.1
  • starts with filter predicate, SQL/JSON path expressions 13.2.1
  • step, SQL/JSON path expressions 13.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 21.1
  • string() item method, SQL/JSON path expressions 13.3
  • stringOnly() item method, SQL/JSON path expressions 13.3
  • support for JSON, Oracle Database A
  • syntax diagrams, basic SQL/JSON path expression B

T

  • time and date formats, ISO 8601 13.4
  • timestamp() item method, SQL/JSON path expressions 13.3
  • tree-like representation of JSON data 22
  • trigger for data-guide changes 20.9
  • TRUNCATE keyword, Oracle extension for SQL/JSON VARCHAR2 return value 18
  • TRUNCATE keyword, Oracle extension for SQL VARCHAR2 return value 14.1
  • type() item method, SQL/JSON path expressions 13.3
  • type data-guide field (JSON Schema keyword) 20.4
  • TYPE ERROR clause, ON MISMATCH clause, json_value 14.5

U

  • UNCONDITIONAL keyword, SQL/JSON query functions 14.2
  • unique field names in JSON objects 5.1
  • updating JSON data 9
  • upper() item method, SQL/JSON path expressions 13.3
  • USER_JSON_COLUMNS view 4.1
  • USER_JSON_DATAGUIDE_FIELDS view 20.5
  • USER_JSON_DATAGUIDES view 20.5
  • user-defined data-guide change trigger 20.9.1

V

  • value, JSON 2.2
  • variable, SQL/JSON path expressions 13.2.1
    • syntax B
  • view
    • create based on a data guide 20.7.1
    • create based on data guide-enabled index and a path 20.7.2
    • create using SQL/JSON function json_table 18.5
  • views
    • ALL_JSON_COLUMNS 4.1
    • ALL_JSON_DATAGUIDE_FIELDS 20.5
    • ALL_JSON_DATAGUIDES 20.5
    • DBA_JSON_COLUMNS 4.1
    • DBA_JSON_DATAGUIDE_FIELDS 20.5
    • DBA_JSON_DATAGUIDES 20.5
    • USER_JSON_COLUMNS 4.1
    • USER_JSON_DATAGUIDE_FIELDS 20.5
    • USER_JSON_DATAGUIDES 20.5
  • virtual columns for JSON fields, adding 20.8
    • based on a data guide-enabled search index 20.8.2
    • based on a hierarchical data guide 20.8.1

W

  • well formed JSON data 5
  • 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 14.2
  • wrapper clause, SQL/JSON query functions 14.2
  • WRAPPER keyword, SQL/JSON query functions 14.2

X

  • XML
    • compared with JSON 2.3
    • DOM 22