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  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, 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
  • BNF syntax descriptions, basic SQL/JSON path expression C
  • 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
  • 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
  • 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 LOB data 7
  • column, JSON 4
  • COLUMNS clause, json_table SQL/JSON function 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
  • conditions, Oracle SQL
    • json_equal IV
    • json_textcontains 21.1
  • conditions, SQL/JSON
  • 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
  • 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 SQL/JSON function 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 SQL/JSON function 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
    • 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 SQL/JSON function 20.2
    • SQL/JSON generation functions 23.1, 23.2
  • FOR ORDINALITY keywords, json_table SQL/JSON function 20.2
  • full-text search of JSON data 21, 21.1
  • function-based indexing
  • functions, Oracle SQL
  • 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-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
    • 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
  • 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 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
  • 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
  • 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

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
  • 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 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, 20.2
  • path expression, SQL/JSON 15, 15.1
  • path expression, SQL/JSON, for a json_table column 20.2
  • 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
  • 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 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
  • 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 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) 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
  • 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
    • 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 a json_table column 20.2
  • 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
  • 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_table SQL/JSON function 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