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

  • _id field, document identifier 6
  • , character (comma) 5.2
  • : character (colon) 5.2
  • != comparison filter predicate, SQL/JSON path expressions 17.2.1, 17.2.3
  • ! filter predicate, SQL/JSON path expressions 17.2.1, 17.2.3
  • / character (solidus, slash) 5.2
  • ' character (single quotation mark) 5.2
  • " character (double quotation mark) 5.2
  • [] characters (brackets) 5.2
  • {} characters (braces) 5.2
  • @ character (at sign, commercial at)
  • $, SQL/JSON path expressions
    • for a SQL/JSON variable 18.1
  • $ character (dollar sign)
    • json_transform RHS 13, 17.2.1
    • SQL/JSON path expressions
      • for a SQL/JSON variable 17.2.1
      • for the context item 17.2.1
  • \ character (reverse solidus, backslash) 5.2
  • && filter predicate, SQL/JSON path expressions 17.2.1
  • <= comparison filter predicate, SQL/JSON path expressions 17.2.1
  • <> comparison filter predicate, SQL/JSON path expressions
    • See: != comparison filter predicate
  • < comparison filter predicate, SQL/JSON path expressions 17.2.1
  • == comparison filter predicate, SQL/JSON path expressions 17.2.1
  • >= comparison filter predicate, SQL/JSON path expressions 17.2.1
  • > comparison filter predicate, SQL/JSON path expressions 17.2.1
  • || filter predicate, SQL/JSON path expressions 17.2.1

A

  • abort_redef_table, DBMS_REDEFINITION PL/SQL procedure D.4
  • abs() item method, SQL/JSON path expressions 17.3
  • ABSENT ON NULL
    • json_scalar 2.2.2
    • SQL/JSON generation functions 25.1
  • absolute path expression 17.2.1
    • syntax C
  • ADD_SET operation, json_transform 13
  • add_vc trigger procedure 24.9
  • add_virtual_columns, DBMS_JSON PL/SQL procedure 24.8, 24.8.1, 24.8.2
  • adding virtual columns for JSON fields 24.8
    • based on a data guide-enabled search index 24.8.2
    • based on a hierarchical or schema data guide 24.8.1
  • ad-hoc query indexing 30.11
  • aggregate item method 17.3
  • ALL_CONSTRAINTS view 7.4, 7.5
  • ALL_JSON_COLLECTION_TABLES view 6
  • ALL_JSON_COLLECTIONS view 6
  • ALL_JSON_COLUMNS view 4.2
  • ALL_JSON_DATAGUIDE_FIELDS view 24.5
  • ALL_JSON_DATAGUIDES view 24.5
  • ALL_JSON_INDEXES view 30.1
  • ALL_JSON_SCHEMA_COLUMNS view 7.1
  • ALL_TAB_COLS view 4.1
  • ALL_TAB_COLUMNS view 4.1
  • ALL_TABLES view 6
  • ALL_VIEWS view 6
  • ALLOW SCALARS keywords, json_query RETURNING clause 18.2
  • alphabetically ordering serialized JSON data 2.2.3
  • APPEND operation, json_transform 13
  • array, JSON 1.2
  • array element, JSON 1.2
  • array-element sorting, json_transform 13
  • array index 17.2.1
  • array range specification 17.2.1
  • array step, SQL/JSON path expressions 17.2.1
    • syntax C
  • ASCII control characters 5.2
  • ASCII keyword
    • json_serialize function 2.2.3
  • ASCII keyword, SQL functions 18.2
  • at sign (@ character)
  • automatic synchronization of JSON search index 30.11
  • avg() item method, SQL/JSON path expressions 17.3

B

  • backslash character 5.2
  • basic SQL/JSON path expression 17.2.1
    • BNF description C
    • diagrams C
  • binary() item method, SQL/JSON path expressions 17.3
  • binaryOnly() item method, SQL/JSON path expressions 17.3
  • binary type, Oracle JSON scalar 2.1.1
  • bind variable, passing a value to a SQL/JSON variable 17.2.1, 18.1
  • BNF syntax descriptions, basic SQL/JSON path expression C
  • boolean() item method, SQL/JSON path expressions 17.3
  • Boolean JSON value
    • generating 25.2
    • targeted by json_value 20.1
    • using FORMAT JSON to set 13
  • booleanOnly() item method, SQL/JSON path expressions 17.3
  • brace characters ({}) 5.2
  • bracket characters ([]) 5.2

C

  • can_redef_table, DBMS_REDEFINITION PL/SQL procedure D.4
  • canonical form of a JSON number 18.2
  • canonical sort order, JSON data type 2.2.6
  • capabilities specification, Oracle Database support for JSON B
  • carriage-return character 5.2
  • CASE operation, json_transform 13
  • case-sensitivity
    • in data-guide field o:preferred_column_name 24.4
    • in query dot notation 16
    • in SQL/JSON path expression 17.2, 17.2.1
    • JSON and SQL
    • strict and lax JSON syntax 5.2
  • CAST, IS JSON VALIDATE check-constraint keyword 7.2
  • ceiling() item method, SQL/JSON path expressions 17.3
  • change trigger, data guide 24.9
  • character sets 8
  • check constraints, NOPRECHECK keyword 7.5
  • check constraints, PRECHECK keyword 7.5
  • check constraint used to ensure well-formed JSON data 4.1
  • child COLUMNS clause, json_table 22.2
  • client, using to retrieve JSON LOB data 9
  • clone() method, PL/SQL object types 26
  • collation order, json_transform array sorting 13
  • collection, JSON 6
  • colon character (:) 5.2
  • column, JSON 4.1
  • column check constraints, NOPRECHECK keyword 7.5
  • column check constraints, PRECHECK keyword 7.5
  • COLUMNS clause
  • columns of JSON data 2.1.3
  • comma character (,) 5.2
  • commercial at sign (@ character)
  • compare predicate, SQL/JSON path expressions
    • syntax C
  • comparing JSON data type values 2.2.6
    • with SQL values from other types 2.2.7
  • comparison, SQL/JSON path expressions
    • syntax C
  • comparison filter predicates, SQL/JSON path expressions 17.2.1
  • comparison in SQL/JSON path expression, types 17.4
  • comparison of SQL values with JSON values 2.2.7
  • compatibility of data types, item methods 17.3
  • composite multivalue function-based index 30.8, 30.9
  • concat() item method, SQL/JSON path expressions 17.3
  • condition (filter), SQL/JSON path expressions 17.2.1, C
  • conditions, Oracle SQL
    • json_equal IV
    • json_textcontains 23.1
  • conditions, SQL/JSON
  • conjunction, SQL/JSON path expressions
    • syntax C
  • constraint, JSON collection table 6
  • constructor, JSON 2.2.4
    • JSON generation 25.1
  • constructor, JSON data type 2.2.1
  • context item, SQL/JSON path expressions 17.2.1
  • control characters 5.2
  • convert textual JSON to JSON data type
    • See: migrate textual JSON to JSON data type
  • copy_table_dependents, DBMS_REDEFINITION PL/SQL procedure D.4
  • COPY operation, json_transform 13
  • cos() item method, SQL/JSON path expressions 17.3
  • count() item method, SQL/JSON path expressions 17.3
  • create_view_on_path, DBMS_JSON PL/SQL procedure 24.7, 24.7.2
  • create_view, DBMS_JSON PL/SQL procedure 24.7, 24.7.1
  • CREATE TABLE AS SELECT, migrate textual JSON data to JSON type D.2
  • creating a JSON schema 7.3
  • curly brace characters ({}) 5.2

D

  • data guide
  • data-guide keywords
    • JSON Schema fields 24.4
  • data types for JSON columns 3
  • date() item method, SQL/JSON path expressions 17.3
  • date formats, ISO 8601 A
  • dateTimeOnly() item method, SQL/JSON path expressions 17.3
  • date type, Oracle JSON scalar 2.1.1
  • day-second interval type, Oracle JSON scalar 2.1.1
  • DBA_CONSTRAINTS view 7.4, 7.5
  • DBA_JSON_COLLECTION_TABLES view 6
  • DBA_JSON_COLLECTIONS view 6
  • DBA_JSON_COLUMNS view 4.2
  • DBA_JSON_DATAGUIDE_FIELDS view 24.5
  • DBA_JSON_DATAGUIDES view 24.5
  • DBA_JSON_INDEXES view 30.1
  • DBA_JSON_SCHEMA_COLUMNS view 7.1
  • DBA_TAB_COLS view 4.1
  • DBA_TAB_COLUMNS view 4.1
  • DBA_TABLES view 6
  • DBA_VIEWS view 6
  • dbAssigned JSON Schema field 7.4
  • dbColumn JSON Schema field 7.4
  • dbConstraintExpression JSON Schema field 7.4
  • dbConstraintName JSON Schema field 7.4
  • dbDomain JSON Schema field 7.4
  • dbFieldProperties JSON Schema field 7.4
  • dbForeignKey JSON Schema field 7.4
  • DBMS_JSON_SCHEMA.describe PL/SQL function 7.3, 7.4
  • DBMS_JSON_SCHEMA.is_schema_valid PL/SQL function 7.1
  • DBMS_JSON.add_virtual_columns PL/SQL procedure 24.8, 24.8.1, 24.8.2
  • DBMS_JSON.create_view_on_path PL/SQL procedure 24.7, 24.7.2
  • DBMS_JSON.create_view PL/SQL procedure 24.7, 24.7.1
  • DBMS_JSON.drop_virtual_columns PL/SQL procedure 24.8, 24.8.3
  • DBMS_JSON.FORMAT_FLAT 24.3, 24.4, 24.12
  • DBMS_JSON.FORMAT_HIERARCHICAL 24.3, 24.7.1, 24.8.1, 24.13
  • DBMS_JSON.FORMAT_SCHEMA 24.3, 24.7.1, 24.8.1, 24.14
  • DBMS_JSON.get_index_dataguide PL/SQL function 24.3, 24.4
  • DBMS_JSON.get_view_sql PL/SQL function 24.7
  • DBMS_JSON.json_type_convertible_check PL/SQL procedure D.1
  • DBMS_JSON.PRETTY 24.7.1, 24.12, 24.13, 24.14
  • DBMS_JSON.rename_column PL/SQL procedure 24.4
  • DBMS_MLE.export_to_mle PL/SQL procedure 2.1.6
  • DBMS_MLE.import_from_mle PL/SQL procedure 2.1.6
  • DBMS_REDEFINITION.abort_redef_table PL/SQL procedure D.4
  • DBMS_REDEFINITION.can_redef_table PL/SQL procedure D.4
  • DBMS_REDEFINITION.copy_table_dependents PL/SQL procedure D.4
  • DBMS_REDEFINITION.finish_redef_table PL/SQL procedure D.4
  • DBMS_REDEFINITION.sync_interim_table PL/SQL procedure D.4
  • dbNoPrecheck JSON Schema field 7.4
  • dbObject JSON Schema field 7.4
  • dbObjectProperties JSON Schema field 7.4
  • dbObjectType JSON Schema field 7.4
  • dbPrimaryKey JSON Schema field 7.4
  • dbUnique JSON Schema field 7.4
  • descendant step, SQL/JSON path expressions 17.2.1
  • describe, DBMS_JSON_SCHEMA PL/SQL function 7.3, 7.4
  • description JSON Schema field 7.4
  • diagrams, basic SQL/JSON path expression syntax C
  • DISALLOW SCALARS keywords
    • json_query 21
    • json_table 22.2
  • DISALLOW SCALARS keywords, json_query RETURNING clause 18.2
  • disjunction, SQL/JSON path expressions
    • syntax C
  • document APIs 6
  • document identifier 6
  • Document Object Model (DOM) 26
  • dollar sign ($ character)
  • DOM-like manipulation of JSON data 26
  • dot-notation access to JSON data 16
    • use with json_table SQL/JSON function 22
  • double() item method, SQL/JSON path expressions 17.3
  • double quotation mark (" character) 5.2
  • double type, Oracle JSON scalar 2.1.1
  • drop_virtual_columns, DBMS_JSON PL/SQL procedure 24.8, 24.8.3
  • dropping virtual columns for JSON fields 24.8, 24.8.3
  • DROP TABLE SQL statement D.4
  • ds_iso_format ISO 8601 duration format A
  • dsInterval() item method, SQL/JSON path expressions 17.3
  • duality view
    • compared to read-only view 25.7
    • in describe output, JSON Schema 7
  • duplicate field names in JSON objects 5.1
  • duration formats, ISO 8601 A

E

  • element of a JSON array 1.2
  • EMPTY STRING ON NULL
    • json_scalar 2.2.2
    • SQL/JSON generation functions 25.1
  • eq_regex filter predicate, SQL/JSON path expressions 17.2.1
  • error clause, SQL query functions and conditions 18.4
  • ERROR ON MISMATCH clause 18.6
  • exists filter predicate, SQL/JSON path expressions 17.2.1
  • EXISTS keyword, json_table 22.2
  • export_to_mle, DBMS_MLE PL/SQL procedure 2.1.6
  • EXTENDED keyword
    • json_serialize function 2.2.3
    • JSON constructor 2.2.1
  • extended object representation of JSON scalars 2.2.5
  • extendedType JSON Schema field 7.4
  • EXTRA DATA clause, ON MISMATCH clause 18.6

F

  • facet search of JSON data 23.2
  • field, JSON object 1.2
  • field name, SQL/JSON path expressions
    • syntax C
  • filter, SQL/JSON path expressions 17.2.1
    • syntax C
  • filter condition, SQL/JSON path expressions 17.2.1
    • syntax C
  • filter expression, SQL/JSON path expressions 17.2.1
  • finish_redef_table, DBMS_REDEFINITION PL/SQL procedure D.4
  • float() item method, SQL/JSON path expressions 17.3
  • float type, Oracle JSON scalar 2.1.1
  • floor() item method, SQL/JSON path expressions 17.3
  • FORMAT_FLAT, package DBMS_JSON 24.3, 24.4, 24.12
  • FORMAT_HIERARCHICAL, package DBMS_JSON 24.3, 24.7.1, 24.8.1, 24.13
  • FORMAT_SCHEMA, package DBMS_JSON 24.3, 24.7.1, 24.8.1, 24.14
  • FORMAT JSON keywords
  • FOR ORDINALITY keywords, json_table 22.2
  • full-text search index 30.11
  • full-text search of JSON data 23, 23.1
  • function-based indexing
  • functions, Oracle SQL
    • json_dataguide 24.3, 24.4
    • json_id 6
    • json_mergepatch 14
    • json_transform 13
  • functions, SQL/JSON
    • json_array 25.4
    • json_arrayagg 25.6
    • json_object 25.3
    • json_objectagg 25.5
    • json_query 21
    • json_scalar 2.2.2, 2.2.4
    • json_serialize 2.2.3, 2.2.4
    • json_table 22
    • json_value 20
      • function-based indexing 30.4
      • indexing for geographic data 28
      • returning an object-type or collection-type instance 20.2
  • function step, SQL/JSON path expressions 17.2.1
    • syntax C

G

  • generating a JSON schema 7.3
  • generation functions, creating a read-only view 25.7
  • generation of JSON data using SQL 25, 25.1
    • input SQL values 25.2
  • geographic JSON data 28
  • GeoJSON 28
  • geometric features in JSON 28
  • get_index_dataguide, DBMS_JSON PL/SQL function 24.3, 24.4
  • get_view_sql, DBMS_JSON PL/SQL function 24.7
  • get() method, PL/SQL object types 26

H

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

I

  • idOnly() item method, SQL/JSON path expressions 17.3
  • IGNORE ON MISMATCH clause 18.6
  • IM column store 31.1
  • import_from_mle, DBMS_MLE PL/SQL procedure 2.1.6
  • index, array 17.2.1
  • indexing JSON data 30
    • composite B-tree index for multiple fields 30.10
    • for json_exists queries 30.6, 30.8, 30.9
    • for json_table queries 30.5
    • for search 30.11
    • full-text and numeric-range 30.11
    • function-based 30.4
      • for geographic data 28
    • GeoJSON 28
    • is (not) json SQL/JSON condition 30.1
    • json_exists SQL/JSON condition 30.3, 30.8, 30.9
    • json_value SQL/JSON function 30.4
      • data type considerations 30.7
      • for geographic data 28
      • for json_exists queries 30.6
      • for json_table queries 30.5
    • multivalue function-based index 30.8
    • spatial 28
  • indexOf() item method, SQL/JSON path expressions 17.3
  • in filter predicate, SQL/JSON path expressions 17.2.1
  • In-Memory Column Store 31.1
    • populating JSON into 31.2
    • upgrading tables with JSON data for 31.3
  • INSERT as SELECT, migrate textual JSON data to JSON type D.2
  • inserting JSON data into a column 12
  • INSERT operation, json_transform 13
  • INTERSECT operation, json_transform 13
  • introspection of PL/SQL object types 26
  • is_schema_valid, DBMS_JSON_SCHEMA PL/SQL function 7.1
  • is json SQL/JSON condition 5
    • and JSON null 1.2
    • indexing 30.1
    • STRICT keyword 5.3
  • is not json SQL/JSON condition 5
    • and JSON null 1.2
    • indexing 30.1
    • STRICT keyword 5.3
  • ISO 8601 formats A
  • item method
    • use with dot-notation syntax 16
  • item method, SQL/JSON path expressions 17.2.1, 17.3
    • data type compatibility 17.3
    • implicit "only" method application 18.1, 18.2, 22.2
    • syntax C
  • items data-guide field (JSON Schema keyword) 24.4
  • items JSON Schema field 7.4

J

  • JavaScript array 1.2
  • JavaScript driver mle-js-oracledb (server side) 2.1.6
  • JavaScript driver node-oracledb (client side) 2.1.6
  • 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 8
    • character-set conversion 8
    • 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 17.2.1, C
      • strict and lax 5.2
  • JSON_ARRAY_T PL/SQL object type 26
  • json_arrayagg SQL/JSON function 25.6
  • json_array SQL/JSON function 25.4
  • JSON_BEHAVIOR parameter
  • json_dataguide Oracle SQL function 24.3, 24.4
  • JSON_ELEMENT_T PL/SQL object type 26
  • json_equal Oracle SQL condition IV
  • json_exists SQL/JSON condition 19
  • json_id Oracle SQL function 6
  • JSON_KEY_LIST PL/SQL object type 26
  • json_mergepatch Oracle SQL function 14
  • JSON_OBJECT_T PL/SQL object type 26
  • json_objectagg SQL/JSON function 25.5
  • json_object SQL/JSON function 25.3
  • json_query SQL/JSON function 21
    • as json_table 21.1
  • JSON_SCALAR_T PL/SQL object type 26
  • json_scalar SQL/JSON function 2.2.2, 2.2.4
  • json_serialize SQL/JSON function 2.2.3, 2.2.4
  • json_table SQL/JSON function 22
    • DISALLOW SCALARS keywords 22.2
    • EXISTS keyword 22.2
    • FORMAT JSON keywords 22.2
    • generalizes other SQL/JSON functions and conditions 22.3
    • indexing for queries 30.5
    • NESTED PATH clause 22.4
    • PATH clause 22, 22.2
    • TRUNCATE keyword 22.2
  • json_textcontains Oracle SQL condition 23.1
  • json_transform Oracle SQL function 13
    • PATH clause 13
  • json_type_convertible_check, DBMS_JSON PL/SQL procedure D.1
  • json_value SQL/JSON function 20
    • as json_table 20.3
    • data type considerations for indexing 30.7
    • function-based indexing 30.4
      • for geographic data 28
    • indexing for json_exists queries 30.6
    • indexing for json_table queries 30.5
    • returning an object-type or collection-type instance 20.2
  • JSON, extended objects 2.2.5
  • JSON collection 6
  • JSON collection table, definition 6
  • JSON collection view, definition 6
  • JSON column 4.1
  • JSON columns 2.1.3
  • JSON constructor 2.2.1
  • JSON data guide 24
  • JSON data type (SQL) 2.1, 2.1.1
    • comparing and sorting 2.2.6
    • comparing with other SQL types 2.2.7
    • migrate from textual JSON D
    • precheck to migrate textual JSON D.1
    • with type modifiers 4.1, 5, 7.1
  • JSON generation functions 25
  • JSON language, Oracle-specific scalar types 1.2
  • JSON-language null and SQL NULL 2.1.2
  • JSON-language scalar types, corresponding to SQL scalar types 2.1.1
  • JSON LOB data 9
  • JSON NULL ON NULL
  • JSON object types, PL/SQL
    • overview 26
  • JSON-relational duality view
    • compared to read-only view 25.7
    • in describe output, JSON Schema 7
  • JSON scalars, object representation 2.2.5
  • JSON scalar types, Oracle extended 2.1.1
  • JSON schema
    • generated from a data guide 24.4
    • generated from database objects 7.4
  • JSON Schema 7, 7.3, 24
    • data-guide keywords 24.4
    • Oracle-specific fields 7.4
    • validating documents 7.1
  • JSON search index 30.11
  • JSON structural characters 5.2
  • JSON type constructor 2.2.1, 2.2.4
    • JSON generation 25.1

K

  • KEEP operation, json_transform 13
  • key, JSON object
    • See: field, JSON object
  • keywords
    • JSON Schema data-guide fields 24.4

L

  • last, array index 17.2.1
  • lax JSON-language type comparison 18.7
  • lax JSON syntax 5.2
    • specifying 5.3
  • LAX keyword
    • in TYPE clause 18.7
  • left-hand side (LHS)of a json_transform operation 13
  • length() item method, SQL/JSON path expressions 17.3
  • LHS (left-hand side) of a json_transform operation 13
  • like_regex filter predicate, SQL/JSON path expressions 17.2.1
  • like filter predicate, SQL/JSON path expressions 17.2.1
  • limitations, Oracle Database support for JSON B
  • line-feed character 5.2
  • line-separator character 5.2
  • listagg() item method, SQL/JSON path expressions 17.3
  • load() PL/SQL JSON-type method, to construct PL/SQL object types 26
  • loading JSON data into the database 12
  • LOB storage of JSON data 9
  • lower() item method, SQL/JSON path expressions 17.3

M

  • materialized view of JSON data 22.5
    • indexing 32
    • rewriting automatically 32
  • max() item method, SQL/JSON path expressions 17.3
  • maxDateTime() item method, SQL/JSON path expressions 17.3
  • maxItems JSON Schema field 7.4
  • maxLength JSON Schema field 7.4
  • maxNumber() item method, SQL/JSON path expressions 17.3
  • maxString() item method, SQL/JSON path expressions 17.3
  • MERGE operation, json_transform 13
  • migrate textual JSON data to JSON data type D
    • handling dependent objects D.5
    • online redefinition D.4
    • populating a new table D.2
    • with Oracle Data Pump D.3
  • migrate textual JSON to JSON data type
    • pre-migration check D.1
  • min() item method, SQL/JSON path expressions 17.3
  • minDateTime() item method, SQL/JSON path expressions 17.3
  • minLength JSON Schema field 7.4
  • minNumber() item method, SQL/JSON path expressions 17.3
  • minString() item method, SQL/JSON path expressions 17.3
  • MINUS operation, json_transform 13
  • MISSING DATA clause, ON MISMATCH clause 18.6
  • mle-js-oracledb MLE JavaScript driver (server side) 2.1.6
  • modifers, JSON data type 4.1, 7.1
    • with IS JSON 5
  • modifying JSON data
    • json_mergepatch 14
    • json_transform 13
  • MongoDB API 2
  • multiple data guides for the same JSON column 24.10
  • multivalue function-based index 30.8, 30.9

N

  • native binary JSON data format (OSON) 2.1, 2.1.1
  • negation in SQL/JSON path expressions 17.2.3
  • NESTED clause, instead of json_table 22.1
  • NESTED PATH clause, json_table 22.4
  • NESTED PATH operation, json_transform 13
  • node-oracledb MLE JavaScript driver (client side) 2.1.6
  • NOPRECHECK keyword for column check constraints 7.5
  • NoSQL databases 2.1
  • null handling, SQL/JSON generation functions 25.2
  • NULL-handling clause
    • json_scalar 2.2.2
    • SQL/JSON generation functions 25.1
  • null in JSON and in SQL 2.1.2
  • NULL ON EMPTY clause, SQL/JSON query functions 18.5
  • nullOnly() item method, SQL/JSON path expressions 17.3
  • NULL ON MISMATCH clause 18.6
  • NULL ON NULL
    • json_scalar 2.2.2
    • SQL/JSON generation functions 25.1
  • number() item method, SQL/JSON path expressions 17.3
  • numberOnly() item method, SQL/JSON path expressions 17.3
  • number syntax 5.2
  • numeral (number syntax) 5.2
  • numeric-range indexing 30.11

O

  • o:frequency data-guide field 24.4
  • o:hidden data-guide field 24.8
  • o:high_value data-guide field 24.4
  • o:last_analyzed data-guide field 24.4
  • o:length data-guide field 24.4
  • o:low_value data-guide field 24.4
  • o:num_nulls data-guide field 24.4
  • o:path data-guide field 24.4
  • o:preferred_column_name data-guide field 24.4
  • o:sample_size data-guide field 24.4
  • object, Javascript and JSON 1.2
  • object literal, Javascript 1.2
  • object member, JSON 1.2
  • object representation of JSON scalars 2.2.5
  • object step, SQL/JSON path expressions 17.2.1
    • syntax C
  • OID identifier for documents 6
  • OMIT QUOTES keywords, json_query function 21
  • ON EMPTY clause, SQL/JSON query functions 18.5
  • oneOf data-guide field (JSON Schema keyword) 24.4
  • online redefinition, using to migrate to JSON data type D.4
  • ON MISMATCH clause 18.6
  • Oracle Database API for MongoDB 2
  • Oracle Data Pump
    • using to migrate to JSON data type D.3
  • Oracle JSON-language scalar types, corresponding to SQL scalar types 2.1.1
  • Oracle scalar types for JSON language 1.2
  • Oracle SQL conditions IV
    • See also: SQL/JSON conditions
    • json_equal IV
    • json_textcontains 23.1
  • Oracle SQL functions IV
    • See also: SQL/JSON functions
  • Oracle support for JSON in the database 2.3
    • specifications B
  • ORDERED keyword
    • json_serialize function 2.2.3
  • ordering serialized JSON data alphabetically 2.2.3
  • OSON binary JSON data format 2.1, 2.1.1

P

  • paragraph-separator character 5.2
  • parameter JSON_BEHAVIOR
  • parent COLUMNS clause, json_table 22.2
  • parsing of JSON data to PL/SQL object types 26
  • partitioning JSON data 10
    • in JSON collection table 6
  • PASSING clause 18.1
  • PATH, nested
    • json_transform 13
  • PATH clause
  • path expression, SQL/JSON 17, 17.1
    • comparison, types 17.4
    • for a json_table column 22.2
    • for a json_transform RHS 13
    • for json_exists 19
    • for json_table rows 22
    • for json_value 20
    • item methods 17.3
    • syntax 17.2, C
  • path expression, SQL/JSON, for json_query 21
  • performance tuning 29
  • PL/SQL, use of JSON data 2.1.5
  • PL/SQL functions
    • DBMS_JSON_SCHEMA.describe 7.4
    • DBMS_JSON.describe 7.3
    • DBMS_JSON.get_index_dataguide 24.3, 24.4
    • DBMS_JSON.get_view_sql 24.7
    • DBMS_JSON.is_schema_valid 7.3
  • PL/SQL object-type methods 26
  • PL/SQL object types
    • overview 26
  • PL/SQL procedures
  • PL/SQL record or index-table type
    • NULL ON EMPTY 18.5
    • NULL ON MISMATCH 18.6
  • precheckability of a column check constraint
    • explicit declaration 7.5
  • precheckable check constraint, definition 7.4
  • PRECHECK keyword for column check constraints 7.5
  • predicate
    • See: filter expression
  • pre-migration check, migration to JSON type D.1
  • PREPEND operation, json_transform 13
  • PRETTY, package DBMS_JSON 24.7.1, 24.12, 24.13, 24.14
  • PRETTY keyword
    • json_serialize function 2.2.3
  • PRETTY keyword, SQL functions 18.2
  • pretty-printing
    • in book examples
  • pretty-printing serialized JSON data 2.2.3
  • projecting virtual columns from JSON fields 24.8
  • properties data-guide field (JSON Schema keyword) 24.4
  • properties JSON Schema field 7.4
  • property, JSON object
    • See: field, JSON object
  • put() method, PL/SQL object types 26

Q

  • queries, dot notation 16
    • use with json_table SQL/JSON function 22
  • query rewrite to a materialized view 32
  • QUOTES keyword, json_query function 21

R

  • range indexing, numeric 30.11
  • range specification, array 17.2.1
  • rawtohex SQL function, for insert or update with BLOB JSON column 9
  • read-only view
    • create using generation functions 25.7
  • regex equals filter predicate, SQL/JSON path expressions 17.2.1
  • regex filter predicate, SQL/JSON path expressions 17.2.1
  • regex like filter predicate, SQL/JSON path expressions 17.2.1
  • relational database with JSON data 2.1
  • relative path expression 17.2.1
    • syntax C
  • REMOVE_SET operation, json_transform 13
  • remove() method, PL/SQL object types 26
  • REMOVE operation, json_transform 13
  • rename_column, DBMS_JSON PL/SQL procedure 24.4
  • rename_key() method, PL/SQL object types 26
  • RENAME operation, json_transform 13
  • rendering of JSON data 18.2
  • REPLACE operation, json_transform 13
  • required JSON Schema field 7.4
  • restrictions, Oracle Database support for JSON B
  • retrieval of JSON LOB data from database by client 9
  • returning an object-type or collection-type instance from json_value 20.2
  • RETURNING clause
    • SQL/JSON generation functions 25.1
    • SQL query functions 18.2
  • reverse solidus (backslash) character 5.2
  • rewrite of JSON queries to a materialized view 32
  • RHS (right-hand side) of a json_transform operation 13
  • right-hand side (RHS)of a json_transform operation 13
  • round() item method, SQL/JSON path expressions 17.3
  • row source, JSON 22

S

  • scalar, SQL/JSON path expressions
    • syntax C
  • scalar types, Oracle JSON-language and SQL 2.1.1
  • scalar types and values, JSON 1.2
    • object representation 2.2.5
  • schema_validate() method, PL/SQL object types 26
  • schema, JSON 7, 7.3, 24
    • validating documents 7.1
  • schemaless database data 2.1
  • schema-valid JSON data 5
  • SDO_GEOMETRY 28
  • search index 30.11
  • searching JSON data 23
  • SELECT statement, NESTED clause instead of json_table 22.1
  • serialization
    • of JSON data from queries 18.2
    • of JSON data in PL/SQL object types 26
  • serializing JSON data 2.2.3
  • SET operation, json_transform 13
  • setting a SQL/JSON variable, json_transform 13
  • setting values in PL/SQL object types 26
  • sharding, data-guide information in index 24.2
  • sibling COLUMNS clauses, json_table 22.2
  • simple dot-notation access to JSON data 16
    • use with json_table SQL/JSON function 22
  • Simple Oracle Document Access (SODA) 2
  • simplified syntax
    • See: simple dot-notation access to JSON data
  • sin() item method, SQL/JSON path expressions 17.3
  • single quotation mark (' character) 5.2
  • size() item method, SQL/JSON path expressions 17.3
  • size2() item method, SQL/JSON path expressions 17.3
  • slash character 5.2
  • SODA 2
  • solidus (slash) character (/) 5.2
  • sorting array elements, json_transform 13
  • sorting JSON data type values 2.2.6
  • SORT operation, json_transform 13
  • sort order, JSON data type 2.2.6
    • json_transform SORT 13
  • spatial JSON data 28
  • specifications, Oracle Database support for JSON B
  • SQL, overview of use with JSON data 2.1.4
  • SQL/JSON conditions IV
    • See also: Oracle SQL conditions
  • SQL/JSON functions IV
    • See also: Oracle SQL functions
    • for generating JSON 25
    • json_array 25.4
    • json_arrayagg 25.6
    • json_object 25.3
    • json_objectagg 25.5
    • json_query 21
      • as json_table 21.1
    • json_scalar 2.2.2, 2.2.4
    • json_serialize 2.2.3, 2.2.4
    • json_table 22
    • json_value 20
      • as json_table 20.3
      • function-based indexing 28, 30.4
      • returning an object-type or collection-type instance 20.2
  • SQL/JSON generation functions 25, 25.1
    • input SQL values 25.2
  • SQL/JSON path expression 17, 17.1
    • comparison, types 17.4
    • for a json_table column 22.2
    • for a json_transform RHS 13
    • for json_exists 19
    • for json_table rows 22
    • for json_value 20
    • item methods 17.3
    • syntax 17.2
      • array step C
      • basic 17.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 17.2.2
      • scalar C
      • variable C
  • SQL/JSON path expression, for json_query 21
  • SQL/JSON query functions
    • WITH WRAPPER keywords 18.3
  • SQL/JSON variable 17.2.1, 18.1
  • SQL/JSON variable, setting with json_transform 13
  • SQL functions
  • SQL NESTED clause, instead of json_table 22.1
  • SQL NULL and JSOn-language null 2.1.2
  • sqlPrecision JSON Schema field 7.4
  • SQL scalar types, corresponding to JSON-language scalar types 2.1.1
  • sqlScale JSON Schema field 7.4
  • SQL statement DROP TABLE D.4
  • SQL values compared with JSON values 2.2.7
  • square bracket characters ([]) 5.2
  • starts with filter predicate, SQL/JSON path expressions 17.2.1
  • stddev() item method, SQL/JSON path expressions 17.3
  • stddevp() item method, SQL/JSON path expressions 17.3
  • step, SQL/JSON path expressions 17.2.1
  • storing and managing JSON data, overview 3
  • strict JSON-language type comparison 18.7
  • strict JSON syntax 5.2
    • specifying 5.3
  • STRICT keyword
    • in TYPE clause 18.7
    • is (not) json SQL/JSON condition 5.3
    • SQL/JSON generation functions 25.1
  • string() item method, SQL/JSON path expressions 17.3
  • stringify() item method, SQL/JSON path expressions 17.3
  • stringOnly() item method, SQL/JSON path expressions 17.3
  • sum() item method, SQL/JSON path expressions 17.3
  • support for JSON, Oracle Database 2.3
    • specifications B
  • sync_interim_table, DBMS_REDEFINITION PL/SQL procedure D.4
  • synonyms for JSON collection names 6
  • syntax diagrams, basic SQL/JSON path expression C

T

  • tab character 5.2
  • tables with JSON data 2.1.3
  • tan() item method, SQL/JSON path expressions 17.3
  • textual JSON, migrate to JSON data type D
    • handling dependent objects D.5
    • online redefinition D.4
    • populating a new table D.2
    • pre-migration check D.1
    • with Oracle Data Pump D.3
  • textual SQL data types for JSON data 2.1.1
  • time formats, ISO 8601 A
  • timestamp() item method, SQL/JSON path expressions 17.3
  • timestamp type, Oracle JSON scalar 2.1.1
  • timestamp with time zone type, Oracle JSON scalar 2.1.1
  • title JSON Schema field 7.4
  • to_json() function, PL/SQL object types 26
  • toBoolean() item method, SQL/JSON path expressions 17.3
  • toDateTime() item method, SQL/JSON path expressions 17.3
  • tree-like representation of JSON data 26
  • trigger for data-guide changes 24.9
  • truncate() item method, SQL/JSON path expressions 17.3
  • TRUNCATE keyword
    • json_serialize function 2.2.3
    • json_table 22.2
  • TRUNCATE keyword, Oracle extension for SQL/JSON VARCHAR2 return value 18.2
  • type() item method, SQL/JSON path expressions 17.3
  • TYPE(STRICT) and RETURNING clause
  • TYPE(STRICT) in json_table COLUMNS clause 22.2
  • type-casting scalar JSON data on insertion 7.2
  • TYPE clause (STRICT or LAX) 18.7
  • type data-guide field (JSON Schema keyword) 24.4
  • TYPE ERROR clause, ON MISMATCH clause 18.6
  • type JSON Schema field 7.4
  • type modifers, JSON data type 4.1, 7.1
    • with IS JSON 5
  • types in path-expression comparisons 17.4

U

  • UNCONDITIONAL keyword, SQL/JSON query functions 18.3
  • UNION operation, json_transform 13
  • unique field names in JSON objects 5.1
  • updating JSON data 12
    • json_mergepatch 14
    • json_transform 13
  • upper() item method, SQL/JSON path expressions 17.3
  • USER_CONSTRAINTS view 7.4, 7.5
  • USER_JSON_COLLECTION_TABLES view 6
  • USER_JSON_COLLECTIONS view 6
  • USER_JSON_COLUMNS view 4.2
  • USER_JSON_DATAGUIDE_FIELDS view 24.5
  • USER_JSON_DATAGUIDES view 24.5
  • USER_JSON_INDEXES view 30.1
  • USER_JSON_SCHEMA_COLUMNS view 7.1
  • USER_TAB_COLS view 4.1
  • USER_TAB_COLUMNS view 4.1
  • USER_TABLES view 6
  • USER_VIEWS view 6
  • user-defined data-guide change trigger 24.9.1
  • UUID identifier for documents 6

V

  • validating JSON data with a JSON schema 7.1
  • validating values in PL/SQL object types 26
  • valid JSON data, definition 7, 7.1
  • valid JSON data (JSON Schema) 5
  • value, JSON language 1.2
  • VALUE keyword for returning LOBs 18.2
  • variable, SQL/JSON path expressions 17.2.1, 18.1
    • setting with json_transform 13
    • syntax C
  • variance() item method, SQL/JSON path expressions 17.3
  • vector() item method, SQL/JSON path expressions 17.3
  • vector type, Oracle JSON scalar 2.1.1
  • view
    • create based on a data guide 24.7.1
    • create based on data guide-enabled index and a path 24.7.2
    • create using generation functions 25.7
    • create using SQL/JSON function json_table 22.5
  • views
    • *_CONSTRAINTS 7.4, 7.5
    • *_JSON_COLLECTION_TABLES 6
    • *_JSON_COLLECTIONS 6
    • *_JSON_COLUMNS 4.2
    • *_JSON_DATAGUIDE_FIELDS 24.5
    • *_JSON_DATAGUIDES 24.5
    • *_JSON_INDEXES 30.1
    • *_JSON_SCHEMA_COLUMNS 7.1
    • *_TAB_COLS 4.1
    • *_TAB_COLUMNS 4.1
    • *_TABLES 6
    • *_VIEWS 6
  • virtual columns for JSON fields, adding 24.8
    • based on a data guide-enabled search index 24.8.2
    • based on a hierarchical or schema data guide 24.8.1

W

  • well-formed JSON data 5
    • ensuring 3
  • whitespace characters 5.2
  • 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 18.3
  • wrapper clause, SQL/JSON query functions 18.3
  • WRAPPER keyword, SQL/JSON query functions 18.3

X

  • XML
    • compared with JSON 1.3
    • DOM 26

Y

  • year-month interval type, Oracle JSON scalar 2.1.1
  • ym_iso_format ISO 8601 duration format A
  • ymInterval() item method, SQL/JSON path expressions 17.3