1. Index

Index

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

Symbols

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

A

  • abs() item method, SQL/JSON path expressions 12.2.1
  • ABSENT ON NULL, SQL/JSON generation functions 19.1
  • absolute simple path expression, SQL/JSON 12.2.1
  • add_vc trigger procedure 18.8
  • add_virtual_columns, DBMS_JSON PL/SQL procedure 18.7, 18.7.1, 18.7.2
  • adding virtual columns for JSON fields 18.7
    • based on a data guide-enabled search index 18.7.2
    • based on a hierarchical data guide 18.7.1
  • ad hoc search of JSON data 24.9
  • ALL_JSON_COLUMNS view 4.1
  • ALL_JSON_DATAGUIDES view 18.1
  • array, JSON 2.2
  • array element, JSON 2.2
  • array step, SQL/JSON path expressions 12.2.1
  • ASCII keyword, SQL/JSON query functions 13.1

B

  • basic SQL/JSON path expression 12.2.1
    • BNF description B
    • diagrams B
  • BNF syntax descriptions, basic SQL/JSON path expression B

C

  • canonical form of a JSON number 13.1
  • case-sensitivity
    • JSON and SQL
  • ceiling() item method, SQL/JSON path expressions 12.2.1
  • change trigger, data guide 18.8
  • check constraint used to ensure well-formed JSON data 4
  • child COLUMNS clause, json_table SQL/JSON function 17
  • COLUMNS clause, json_table SQL/JSON function 17
  • comparison filter predicates, SQL/JSON path expressions 12.2.1
  • condition,
    • See: filter condition, SQL/JSON path expressions
  • conditions, SQL/JSON
    • is json 5
      • and JSON null 2.2
    • is not json 5
      • and JSON null 2.2
    • json_exists 14
    • json_textcontains 24.9
  • context item, SQL/JSON path expressions 12.2.1
  • create_view_on_path, DBMS_JSON PL/SQL procedure 18.6, 18.6.2
  • create_view, DBMS_JSON PL/SQL procedure 18.6, 18.6.1

D

  • data guide 18.1
  • date() item method, SQL/JSON path expressions 12.2.1
  • DBA_JSON_COLUMNS view 4.1
  • DBA_JSON_DATAGUIDES view 18.1
  • DBMS_JSON.add_virtual_columns PL/SQL procedure 18.7, 18.7.1, 18.7.2
  • DBMS_JSON.create_view_on_path PL/SQL procedure 18.6, 18.6.2
  • DBMS_JSON.create_view PL/SQL procedure 18.6, 18.6.1
  • DBMS_JSON.drop_virtual_columns PL/SQL procedure 18.7, 18.7.3
  • DBMS_JSON.FORMAT_HIERARCHICAL 18.7.1, 18.12
  • DBMS_JSON.get_index_dataguide PL/SQL function 18.3, 18.4, 18.6.1, 18.7.1
  • DBMS_JSON.PRETTY 18.12
  • DBMS_JSON.rename_column PL/SQL procedure 18.4
  • diagrams, basic SQL/JSON path expression syntax B
  • Document Object Model (DOM) 20
  • DOM-like manipulation of JSON data 20
  • double() item method, SQL/JSON path expressions 12.2.1
  • drop_virtual_columns, DBMS_JSON PL/SQL procedure 18.7, 18.7.3
  • dropping virtual columns for JSON fields 18.7, 18.7.3
  • duplicate field names in JSON objects 5.1

E

  • element of a JSON array 2.2
  • error clause, SQL/JSON query functions and conditions 13.3
  • exists filter predicate, SQL/JSON path expressions 12.2.1
  • EXISTS keyword, json_table SQL/JSON function 17

F

  • field, JSON object 2.2
  • filter condition, SQL/JSON path expressions 12.2.1
  • filter expression, SQL/JSON path expressions 12.2.1
  • floor() item method, SQL/JSON path expressions 12.2.1
  • FORMAT_HIERARCHICAL, package DBMS_JSON 18.7.1, 18.12
  • FORMAT JSON keywords
    • json_table SQL/JSON function 17
    • SQL/JSON generation functions 19.1
  • FOR ORDINALITY keywords, json_table SQL/JSON function 17
  • full-text search of JSON data 24.9
  • functions, SQL
    • json_dataguide 18.3
      • as an aggregate function 18.9
      • hierarchical format 18.12
      • pretty-print format 18.12
  • functions, SQL/JSON
    • json_array 19.3
    • json_arrayagg 19.5
    • json_object 19.2
    • json_objectagg 19.4
    • json_query 16
    • json_table 17
    • json_value 15
      • function-based indexing 24.4
      • indexing for geographic data 22
      • null JSON value 15.2
  • function step, SQL/JSON path expressions 12.2.1

G

  • generation of JSON data using SQL , 19, 19.1
  • geographic JSON data 22
  • GeoJSON 22
  • geometric features in JSON 22
  • get_index_dataguide, DBMS_JSON PL/SQL function 18.3, 18.4, 18.6.1, 18.7.1
  • get() method, PL/SQL object types 20

H

  • hidden virtual columns projected from JSON data 18.7

I

  • IM column store 25.1
  • indexing JSON data 24
    • composite B-tree index for multiple fields 24.8
    • for json_exists queries 24.6
    • for json_table queries 24.5
    • for search 24.9
    • full-text and numeric-range 24.9
    • function-based 24.4
      • for geographic data 22
    • GeoJSON 22
    • is (not) json SQL/JSON condition 24.1
    • json_exists SQL/JSON condition 24.3
    • json_value SQL/JSON function 24.4
      • data type considerations 24.7
      • for geographic data 22
      • for json_exists queries 24.6
      • for json_table queries 24.5
    • spatial 22
  • In-Memory Column Store 25.1
    • populating JSON into 25.2
    • upgrading tables with JSON data for 25.3
  • inserting JSON data into a column 9
  • introspection of PL/SQL object types 20
  • is json SQL/JSON condition 5
    • and JSON null 2.2
    • indexing 24.1
    • STRICT keyword 5.3
  • is not json SQL/JSON condition 5
    • and JSON null 2.2
    • indexing 24.1
    • STRICT keyword 5.3
  • item method, SQL/JSON path expressions 12.2.1
  • items data-guide field (JSON Schema keyword) 18.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 12.2.1, B
      • strict and lax 5.2
  • JSON_ARRAY_T PL/SQL object type 20
  • json_arrayagg SQL/JSON function 19.5
  • json_array SQL/JSON function 19.3
  • json_dataguide SQL function 18.3
    • as an aggregate function 18.9
    • hierarchical format 18.12
    • pretty-print format 18.12
  • JSON_ELEMENT_T PL/SQL object type 20
  • json_exists SQL/JSON condition 14
  • JSON_KEY_LIST PL/SQL object type 20
  • JSON_OBJECT_T PL/SQL object type 20
  • json_objectagg SQL/JSON function 19.4
  • json_object SQL/JSON function 19.2
  • json_query SQL/JSON function 16
    • as json_table 16.1
    • PRETTY keyword 13.1
  • JSON_SCALAR_T PL/SQL object type 20
  • json_table SQL/JSON function 17
    • EXISTS keyword 17
    • FORMAT JSON keywords 17
    • FOR ORDINALITY keywords 17
    • generalizes other SQL/JSON functions and conditions 17.1
    • indexing for queries 24.5
    • NESTED PATH clause 17.2
    • PATH clause 17
  • json_textcontains SQL/JSON condition 24.9
  • json_value SQL/JSON function 15
    • as json_table 15.3
    • data type considerations for indexing 24.7
    • function-based indexing 24.4
      • for geographic data 22
    • indexing for json_exists queries 24.6
    • indexing for json_table queries 24.5
    • null JSON value 15.2
  • JSON data guide 18
  • JSON generation functions , 19
  • JSON object types, PL/SQL
    • overview 20
  • JSON Schema 18
  • JSON search index 24.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 12.2.1
  • limitations, Oracle Database support for JSON A
  • loading JSON data into the database 9
  • lower() item method, SQL/JSON path expressions 12.2.1

M

  • materialized view of JSON data 17.3
  • multiple data guides for the same JSON column 18.9

N

  • NESTED PATH clause, json_table 17.2
  • null handling, SQL/JSON generation functions 19.1
  • NULL-handling clause, SQL/JSON generation functions 19.1
  • NULL ON EMPTY clause, SQL/JSON query functions 13.4
  • NULL ON NULL, SQL/JSON generation functions 19.1
  • number() item method, SQL/JSON path expressions 12.2.1
  • numeric-range indexing 24.9

O

  • o:frequency data-guide field 18.4
  • o:hidden data-guide field 18.7
  • o:high_value data-guide field 18.4
  • o:last_analyzed data-guide field 18.4
  • o:length data-guide field 18.4
  • o:low_value data-guide field 18.4
  • o:num_nulls data-guide field 18.4
  • o:path data-guide field 18.4
  • o:preferred_column_name data-guide field 18.4
  • object, Javascript and JSON 2.2
  • object literal, Javascript 2.2
  • object member, JSON 2.2
  • object step, SQL/JSON path expressions 12.2.1
  • ON EMPTY clause, SQL/JSON query functions 13.4
  • oneOf data-guide field (JSON Schema keyword) 18.4
  • Oracle SQL functions
    • json_dataguide 18.3
      • as an aggregate function 18.9
      • hierarchical format 18.12
      • pretty-print format 18.12
  • Oracle support for JSON in the database A

P

  • parent COLUMNS clause, json_table SQL/JSON function 17
  • parsing of JSON data to PL/SQL object types 20
  • PATH clause, json_table 17
  • path expression, SQL/JSON 12, 12.1
  • performance tuning 23
  • PL/SQL functions
  • PL/SQL object types
    • overview 20
  • PL/SQL procedures
  • PRETTY, package DBMS_JSON 18.12
  • PRETTY keyword, json_query 13.1
  • pretty-printing
    • in book examples
  • projecting virtual columns from JSON fields 18.7
  • properties data-guide field (JSON Schema keyword) 18.4
  • property, JSON object
    • See: field, JSON object
  • put() method, PL/SQL object types 20

R

  • rawtohex SQL function, for insert or update with BLOB JSON column 3
  • relative simple path expression, SQL/JSON 12.2.1
  • rename_column, DBMS_JSON PL/SQL procedure 18.4
  • rendering of JSON data 13.1
  • restrictions, Oracle Database support for JSON A
  • RETURNING clause
    • SQL/JSON generation functions 19.1
    • SQL/JSON query functions 13.1
  • row source, JSON
    • definition 17

S

  • scalar value, JSON 2.2
  • schema, JSON 18
  • SDO_GEOMETRY 22
  • searching JSON data 24.9
  • serialization
    • of JSON data from queries 13.1
    • of JSON data in PL/SQL object types 20
  • setting values in PL/SQL object types 20
  • sharding, data-guide information in index 18.2
  • sibling COLUMNS clauses, json_table SQL/JSON function 17
  • Simple Oracle Document Access (SODA) 1
  • simple path expression, SQL/JSON 12.2.1
  • SODA 1
  • spatial JSON data 22
  • SQL/JSON conditions
    • is (not) json 5
    • is json
    • is not json
    • json_exists 14
    • json_textcontains 24.9
  • SQL/JSON functions
    • for generating JSON , 19
    • for querying 1.1
    • json_array 19.3
    • json_arrayagg 19.5
    • json_object 19.2
    • json_objectagg 19.4
    • json_query 16
      • as json_table 16.1
    • json_table 17
    • json_value 15
      • as json_table 15.3
      • function-based indexing 22, 24.4
      • null JSON value 15.2
  • SQL/JSON generation functions 19, 19.1
  • SQL/JSON path expression 12, 12.1
  • SQL/JSON query functions 1.1
    • WITH WRAPPER keywords 13.2
  • SQL/JSON variable 12.2.1
  • SQL functions
    • json_dataguide 18.3
      • as an aggregate function 18.9
      • hierarchical format 18.12
      • pretty-print format 18.12
  • step, SQL/JSON path expressions 12.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 19.1
  • string() item method, SQL/JSON path expressions 12.2.1
  • support for JSON, Oracle Database A
  • syntax diagrams, basic SQL/JSON path expression B

T

  • timestamp() item method, SQL/JSON path expressions 12.2.1
  • tree-like representation of JSON data 20
  • trigger for data-guide changes 18.8
  • type data-guide field (JSON Schema keyword) 18.4

U

  • UNCONDITIONAL keyword, SQL/JSON query functions 13.2
  • unique field names in JSON objects 5.1
  • updating a JSON column 9
  • upper() item method, SQL/JSON path expressions 12.2.1
  • USER_JSON_COLUMNS view 4.1
  • USER_JSON_DATAGUIDES view 18.1
  • user-defined data-guide change trigger 18.8.1

V

  • value, JSON 2.2
  • variable, SQL/JSON path expressions 12.2.1
  • view
    • create based on a data guide 18.6.1
    • create based on data guide-enabled index and a path 18.6.2
    • create using SQL/JSON function json_table 17.3
  • views
    • ALL_JSON_COLUMNS 4.1
    • ALL_JSON_DATAGUIDES 18.1
    • DBA_JSON_COLUMNS 4.1
    • DBA_JSON_DATAGUIDES 18.1
    • USER_JSON_COLUMNS 4.1
    • USER_JSON_DATAGUIDES 18.1
  • virtual columns for JSON fields, adding 18.7
    • based on a data guide-enabled search index 18.7.2
    • based on a hierarchical data guide 18.7.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 13.2
  • wrapper clause, SQL/JSON query functions 13.2
  • WRAPPER keyword, SQL/JSON query functions 13.2

X

  • XML
    • compared with JSON 2.3
    • DOM 20