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
  • 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
  • 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
    • 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
  • 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
  • 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
  • JSON generation functions 23
  • JSON LOB data 7
  • JSON object types, PL/SQL
    • overview 24
  • JSON Schema 22
  • JSON search index 28.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 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
  • performance tuning 27
  • PL/SQL functions
  • PL/SQL object-type methods 24
  • PL/SQL object types
    • overview 24
  • PL/SQL procedures
  • 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
    • is not json
    • json_exists 17
    • 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