Index

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

A

  • abs() item method, SQL/JSON path expressions 1
  • ABSENT ON NULL, SQL/JSON generation functions 1
  • absolute simple path expression, SQL/JSON 1
  • add_vc trigger procedure 1
  • add_virtual_columns, DBMS_JSON PL/SQL procedure 1 , 2 , 3
  • adding virtual columns for JSON fields
    • based on a data guide-enabled search index 1
    • based on a hierarchical data guide 1
  • ad hoc search of JSON data 1
  • ALL_JSON_COLUMNS view 1
  • ALL_JSON_DATAGUIDES view 1
  • array, JSON 1
  • array element, JSON 1
  • array step, SQL/JSON path expressions 1
  • ASCII keyword, SQL/JSON query functions 1

B

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

C

  • canonical form of a JSON number 1
  • ceiling() item method, SQL/JSON path expressions 1
  • change trigger, data guide
    • user-defined 1
  • check constraint used to ensure well-formed JSON data 1
  • child COLUMNS clause, json_table SQL/JSON function 1
  • COLUMNS clause, json_table SQL/JSON function 1
  • comparison filter predicates, SQL/JSON path expressions 1
  • condition,
    • See: filter condition, SQL/JSON path expressions
  • conditions, SQL/JSON
    • is json
      • and JSON null 1
    • is not json
      • and JSON null 1
    • json_exists
      • indexing 1
    • json_textcontains 1
  • context item, SQL/JSON path expressions 1
  • create_view_on_path, DBMS_JSON PL/SQL procedure 1 , 2
  • create_view, DBMS_JSON PL/SQL procedure 1 , 2

D

  • data guide
    • change trigger
      • user-defined 1
    • fields 1
    • flat 1
    • hierarchical 1
    • multiple for the same JSON column 1
  • date() item method, SQL/JSON path expressions 1
  • DBA_JSON_COLUMNS view 1
  • DBA_JSON_DATAGUIDES view 1
  • DBMS_JSON.add_virtual_columns PL/SQL procedure 1 , 2 , 3
  • DBMS_JSON.create_view_on_path PL/SQL procedure 1 , 2
  • DBMS_JSON.create_view PL/SQL procedure 1 , 2
  • DBMS_JSON.drop_virtual_columns PL/SQL procedure 1 , 2
  • DBMS_JSON.get_index_dataguide PL/SQL function 1 , 2 , 3 , 4
  • DBMS_JSON.rename_column PL/SQL procedure 1
  • diagrams, basic SQL/JSON path expression syntax 1
  • Document Object Model (DOM) 1
  • DOM-like manipulation of JSON data 1
  • double() item method, SQL/JSON path expressions 1
  • drop_virtual_columns, DBMS_JSON PL/SQL procedure 1 , 2
  • dropping virtual columns for JSON fields 1 , 3
  • duplicate field names in JSON objects 1

E

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

F

  • field, JSON object 1
  • filter condition, SQL/JSON path expressions 1
  • filter expression, SQL/JSON path expressions 1
  • floor() item method, SQL/JSON path expressions 1
  • FORMAT JSON keywords
    • json_table SQL/JSON function 1
    • SQL/JSON generation functions 1
  • FOR ORDINALITY keywords, json_table SQL/JSON function 1
  • full-text search of JSON data 1
  • functions, SQL
    • json_dataguide
      • as an aggregate function 1
  • functions, SQL/JSON
    • json_array 1
    • json_arrayagg 1
    • json_object 1
    • json_objectagg 1
    • json_query 1
    • json_table 1
    • json_value
      • function-based indexing 1
      • indexing for geographic data 1
      • null JSON value 1
  • function step, SQL/JSON path expressions 1

G

  • generation of JSON data using SQL 1 , 2 , 3
  • geographic JSON data 1
  • GeoJSON 1
  • geometric features in JSON 1
  • get_index_dataguide, DBMS_JSON PL/SQL function 1 , 2 , 3 , 4
  • get() method, PL/SQL object types 1

H

  • hidden virtual columns projected from JSON data 1

I

  • IM column store 1
  • indexing JSON data
    • composite B-tree index for multiple fields 1
    • for json_exists queries 1
    • for json_table queries 1
    • for search 1
    • full-text and numeric-range 1
    • function-based
      • for geographic data 1
    • GeoJSON 1
    • is (not) json SQL/JSON condition 1
    • json_exists SQL/JSON condition 1
    • json_value SQL/JSON function
      • data type considerations 1
      • for geographic data 1
      • for json_exists queries 1
      • for json_table queries 1
    • spatial 1
  • In-Memory Column Store
    • populating JSON into 1
    • upgrading tables with JSON data for 1
  • inserting JSON data into a column 1
  • introspection of PL/SQL object types 1
  • is json SQL/JSON condition
    • and JSON null 1
    • indexing 1
    • STRICT keyword 1
  • is not json SQL/JSON condition
    • and JSON null 1
    • indexing 1
    • STRICT keyword 1
  • item method, SQL/JSON path expressions 1
  • items data-guide field (JSON Schema keyword) 1

J

  • JavaScript array 1
  • JavaScript notation compared with JSON 1
  • JavaScript object 1
  • JavaScript object literal 1
  • JavaScript Object Notation (JSON) 1
  • JSON
    • character encoding 1
    • character-set conversion 1
    • compared with JavaScript notation 1
    • compared with XML 1
    • overview 1 , 2
    • support by Oracle Database, restrictions 1
    • syntax
      • basic path expression 1 , 2
      • strict and lax 1
  • JSON_ARRAY_T PL/SQL object type 1
  • json_arrayagg SQL/JSON function 1
  • json_array SQL/JSON function 1
  • json_dataguide SQL function
    • as an aggregate function 1
  • JSON_ELEMENT_T PL/SQL object type 1
  • json_exists SQL/JSON condition
    • as json_table 1
    • indexing 1 , 2 , 3
  • JSON_KEY_LIST PL/SQL object type 1
  • JSON_OBJECT_T PL/SQL object type 1
  • json_objectagg SQL/JSON function 1
  • json_object SQL/JSON function 1
  • json_query SQL/JSON function
    • as json_table 1
    • PRETTY keyword 1
  • JSON_SCALAR_T PL/SQL object type 1
  • json_table SQL/JSON function
    • EXISTS keyword 1
    • FORMAT JSON keywords 1
    • FOR ORDINALITY keywords 1
    • generalizes other SQL/JSON functions and conditions 1
    • indexing for queries 1
    • NESTED PATH clause 1
    • PATH clause 1
  • json_textcontains SQL/JSON condition 1
  • json_value SQL/JSON function
    • as json_table 1
    • data type considerations for indexing 1
    • function-based indexing
      • for geographic data 1
    • indexing for json_exists queries 1
    • indexing for json_table queries 1
    • null JSON value 1
  • JSON data guide 1
  • JSON generation functions 1 , 2
  • JSON object types, PL/SQL
    • overview 1
  • JSON Schema
    • keywords 1
  • JSON search index 1

K

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

L

  • lax JSON syntax
    • specifying 1
  • length() item method, SQL/JSON path expressions 1
  • limitations, Oracle Database support for JSON 1
  • loading JSON data into the database 1
  • lower() item method, SQL/JSON path expressions 1

M

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

N

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

O

  • o:frequency data-guide field 1
  • o:hidden data-guide field 1
  • o:high_value data-guide field 1
  • o:last_analyzed data-guide field 1
  • o:length data-guide field 1
  • o:low_value data-guide field 1
  • o:num_nulls data-guide field 1
  • o:path data-guide field 1
  • o:preferred_column_name data-guide field 1
  • object, Javascript and JSON 1
  • object literal, Javascript 1
  • object member, JSON 1
  • object step, SQL/JSON path expressions 1
  • ON EMPTY clause, SQL/JSON query functions 1
  • oneOf data-guide field (JSON Schema keyword) 1
  • Oracle SQL functions
    • json_dataguide
      • as an aggregate function 1
  • Oracle support for JSON in the database 1

P

  • parent COLUMNS clause, json_table SQL/JSON function 1
  • parsing of JSON data to PL/SQL object types 1
  • PATH clause, json_table 1
  • path expression, SQL/JSON
    • syntax 1
  • performance tuning 1
  • PL/SQL functions
    • DBMS_JSON.get_index_dataguide 1 , 2 , 3 , 4
  • PL/SQL object types
    • overview 1
  • PL/SQL procedures
    • DBMS_JSON.add_virtual_columns 1 , 2 , 3
    • DBMS_JSON.create_view 1 , 2
    • DBMS_JSON.create_view_on_path 1 , 2
    • DBMS_JSON.drop_virtual_columns 1 , 2
    • DBMS_JSON.rename_column 1
  • PRETTY keyword, json_query 1
  • pretty-printing
    • in book examples 1
  • projecting virtual columns from JSON fields 1
  • properties data-guide field (JSON Schema keyword) 1
  • property, JSON object
    • See: field, JSON object
  • put() method, PL/SQL object types 1

R

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

S

  • scalar value, JSON 1
  • schema, JSON 1
  • SDO_GEOMETRY 1
  • searching JSON data 1
  • serialization
    • of JSON data from queries 1
    • of JSON data in PL/SQL object types 1
  • setting values in PL/SQL object types 1
  • sharding, data-guide information in index 1
  • sibling COLUMNS clauses, json_table SQL/JSON function 1
  • Simple Oracle Document Access (SODA) 1
  • simple path expression, SQL/JSON 1
  • SODA 1
  • spatial JSON data 1
  • SQL/JSON conditions
    • is (not) json 1
    • is json
      • and JSON null 1
      • indexing 1
    • is not json
      • and JSON null 1
      • indexing 1
    • json_exists
      • as json_table 1
      • indexing 1 , 2
    • json_textcontains 1
  • SQL/JSON functions
    • for generating JSON 1 , 2
    • for querying 1
    • json_array 1
    • json_arrayagg 1
    • json_object 1
    • json_objectagg 1
    • json_query
      • as json_table 1
    • json_table 1
    • json_value
      • as json_table 1
      • function-based indexing 1 , 2
      • null JSON value 1
  • SQL/JSON generation functions 1 , 2
  • SQL/JSON path expression
    • syntax
      • basic 1 , 2
      • relaxed 1
  • SQL/JSON query functions
    • WITH WRAPPER keywords 1
  • SQL/JSON variable 1
  • SQL functions
    • json_dataguide
      • as an aggregate function 1
  • step, SQL/JSON path expressions 1
  • storing and managing JSON data, overview 1
  • strict JSON syntax
    • specifying 1
  • STRICT keyword
    • is (not) json SQL/JSON condition 1
    • SQL/JSON generation functions 1
  • string() item method, SQL/JSON path expressions 1
  • support for JSON, Oracle Database 1
  • syntax diagrams, basic SQL/JSON path expression 1

T

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

U

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

V

  • value, JSON 1
  • variable, SQL/JSON path expressions 1
  • view
    • create based on a data guide 1
    • create based on data guide-enabled index and a path 1
    • create using SQL/JSON function json_table 1
  • views
    • ALL_JSON_COLUMNS 1
    • ALL_JSON_DATAGUIDES 1
    • DBA_JSON_COLUMNS 1
    • DBA_JSON_DATAGUIDES 1
    • USER_JSON_COLUMNS 1
    • USER_JSON_DATAGUIDES 1
  • virtual columns for JSON fields, adding
    • based on a data guide-enabled search index 1
    • based on a hierarchical data guide 1

W

  • well formed JSON data 1
  • WITHOUT UNIQUE KEYS keywords, JSON condition is json 1
  • WITH UNIQUE KEYS keywords, JSON condition is json 1
  • WITH WRAPPER keywords, SQL/JSON query functions 1
  • wrapper clause, SQL/JSON query functions 1
  • WRAPPER keyword, SQL/JSON query functions 1

X

  • XML
    • compared with JSON 1
    • DOM 1