Symbols
- != comparison filter predicate, SQL/JSON path expressions 13.2.1
- ! filter predicate, SQL/JSON path expressions 13.2.1
- $, SQL/JSON path expressions
- && filter predicate, SQL/JSON path expressions 13.2.1
- <= comparison filter predicate, SQL/JSON path expressions 13.2.1
- <> comparison filter predicate, SQL/JSON path
expressions 13.2.1
- < comparison filter predicate, SQL/JSON path expressions 13.2.1
- == comparison filter predicate, SQL/JSON path expressions 13.2.1
- >= comparison filter predicate, SQL/JSON path expressions 13.2.1
- > comparison filter predicate, SQL/JSON path expressions 13.2.1
- || filter predicate, SQL/JSON path expressions 13.2.1
A
- abs() item method, SQL/JSON path expressions 13.3
- ABSENT ON NULL, SQL/JSON generation functions 21.1
- absolute path expression 13.2.1
- add_vc trigger procedure 20.9
- add_virtual_columns, DBMS_JSON PL/SQL procedure 20.8, 20.8.1, 20.8.2
- adding virtual columns for JSON fields 20.8
- based on a data guide-enabled search index 20.8.2
- based on a hierarchical data guide 20.8.1
- ad hoc search of JSON data 26.9
- ALL_JSON_COLUMNS view 4.1
- ALL_JSON_DATAGUIDE_FIELDS view 20.5
- ALL_JSON_DATAGUIDES view 20.5
- array, JSON 2.2
- array element, JSON 2.2
- array index 13.2.1
- array range specification 13.2.1
- array step, SQL/JSON path expressions 13.2.1
- ASCII keyword, SQL functions 14.1
B
- basic SQL/JSON path expression 13.2.1
- BNF
description B
- diagrams B
- BNF syntax descriptions, basic SQL/JSON path expression B
- boolean() item method, SQL/JSON path expressions 13.3
- booleanOnly() item method, SQL/JSON path expressions 13.3
C
- canonical form of a JSON number 14.1
- case-sensitivity
- in data-guide field o:preferred_column_name 20.4
- in query dot notation 12
- in SQL/JSON path expression 13.2, 13.2.1
- JSON and SQL
- strict and lax JSON syntax 5.2
- ceiling() item method, SQL/JSON path expressions 13.3
- change trigger, data guide 20.9
- character sets 6
- check constraint used to ensure well-formed JSON data 4
- child COLUMNS clause, json_table SQL/JSON function 18.2
- COLUMNS clause, json_table SQL/JSON function 18.2
- compare predicate, SQL/JSON path
expressions
- comparison, SQL/JSON path
expressions
- comparison filter predicates, SQL/JSON path expressions 13.2.1
- comparison in SQL/JSON path expression, types 13.5
- compatibility of data types, item methods 13.3
- condition, SQL/JSON path
expressions
- conditions, Oracle SQL
- conditions, SQL/JSON
- is json 5
- is not json 5
- json_exists 15
- json_textcontains 26.9
- conjunction, SQL/JSON path
expressions
- context item, SQL/JSON path expressions 13.2.1
- create_view_on_path, DBMS_JSON PL/SQL procedure 20.7, 20.7.2
- create_view, DBMS_JSON PL/SQL procedure 20.7, 20.7.1
D
- data guide
- date() item method, SQL/JSON path expressions 13.3
- date and time formats, ISO 8601 13.4
- DBA_JSON_COLUMNS view 4.1
- DBA_JSON_DATAGUIDE_FIELDS view 20.5
- DBA_JSON_DATAGUIDES view 20.5
- DBMS_JSON.add_virtual_columns PL/SQL procedure 20.8, 20.8.1, 20.8.2
- DBMS_JSON.create_view_on_path PL/SQL procedure 20.7, 20.7.2
- DBMS_JSON.create_view PL/SQL procedure 20.7, 20.7.1
- DBMS_JSON.drop_virtual_columns PL/SQL procedure 20.8, 20.8.3
- DBMS_JSON.FORMAT_FLAT 20.3, 20.4, 20.12
- DBMS_JSON.FORMAT_HIERARCHICAL 20.3, 20.7.1, 20.8.1, 20.13
- DBMS_JSON.get_index_dataguide PL/SQL function 20.3, 20.4, 20.7.1, 20.8.1
- DBMS_JSON.PRETTY 20.7.1, 20.12, 20.13
- DBMS_JSON.rename_column PL/SQL procedure 20.4
- descendant step, SQL/JSON path expressions 13.2.1
- diagrams, basic SQL/JSON path expression syntax B
- disjunction, SQL/JSON path
expressions
- Document Object Model (DOM) 22
- DOM-like manipulation of JSON data 22
- dot-notation access to JSON data 12
- use with json_table SQL/JSON
function 18
- double() item method, SQL/JSON path expressions 13.3
- drop_virtual_columns, DBMS_JSON PL/SQL procedure 20.8, 20.8.3
- dropping virtual columns for JSON fields 20.8, 20.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 13.2.1
- error clause, SQL query functions and conditions 14.3
- ERROR ON MISMATCH clause, json_value 14.5
- exists filter predicate, SQL/JSON path expressions 13.2.1
- EXISTS keyword, json_table SQL/JSON function 18
- EXTRA DATA clause, ON MISMATCH clause, json_value 14.5
F
- field, JSON object 2.2
- field name, SQL/JSON path
expressions
- filter, SQL/JSON path
expressions
- filter condition, SQL/JSON path expressions 13.2.1
- filter expression, SQL/JSON path expressions 13.2.1
- floor() item method, SQL/JSON path expressions 13.3
- FORMAT_FLAT, package DBMS_JSON 20.3, 20.4, 20.12
- FORMAT_HIERARCHICAL, package DBMS_JSON 20.3, 20.7.1, 20.8.1, 20.13
- FORMAT JSON keywords
- json_table SQL/JSON
function 18.2
- SQL/JSON generation
functions 21.1, 21.2
- FOR ORDINALITY keywords, json_table SQL/JSON function 18
- full-text search of JSON data 26.9
- functions, Oracle SQL
- functions, SQL
- json_dataguide 20.3, 20.4
- as an aggregate function 20.10
- hierarchical format 20.13
- pretty-print format 20.13
- json_mergepatch 9
- functions, SQL/JSON
- json_array 21.4
- json_arrayagg 21.6
- json_object 21.3
- json_objectagg 21.5
- json_query 17
- json_table 18
- json_value 16
- function-based indexing 26.4
- indexing for geographic data 24
- null JSON value 16.2
- returning an
object-type instance 16.3
- function step, SQL/JSON path expressions 13.2.1
G
- generation of JSON data using SQL 21, 21.1
- geographic JSON data 24
- GeoJSON 24
- geometric features in JSON 24
- get_index_dataguide, DBMS_JSON PL/SQL function 20.3, 20.4, 20.7.1, 20.8.1
- get() method, PL/SQL object types 22
H
- has substring filter predicate, SQL/JSON path expressions 13.2.1
- hidden virtual columns projected from JSON data 20.8
I
- IGNORE ON MISMATCH clause, json_value 14.5
- IM column store 27.1
- index, array 13.2.1
- indexing JSON data 26
- composite B-tree index for multiple fields 26.8
- for json_exists queries 26.6
- for json_table queries 26.5
- for
search 26.9
- full-text and
numeric-range 26.9
- function-based 26.4
- GeoJSON 24
- is (not) json SQL/JSON condition 26.1
- json_exists SQL/JSON condition 26.3
- json_value SQL/JSON function 26.4
- data type considerations 26.7
- for geographic data 24
- for
json_exists queries 26.6
- for json_table queries 26.5
- spatial 24
- In-Memory Column Store 27.1
- populating JSON into 27.2
- upgrading tables with JSON data for 27.3
- inserting JSON data into a column 9
- introspection of PL/SQL object types 22
- is json SQL/JSON condition 5
- and JSON null 2.2
- indexing 26.1
- STRICT keyword 5.3
- is not json SQL/JSON condition 5
- and JSON null 2.2
- indexing 26.1
- STRICT keyword 5.3
- ISO 8601 date and time formats 13.4
- item method, SQL/JSON path expressions 13.2.1, 13.3
- data type
compatibility 13.3
- syntax B
- items data-guide field (JSON Schema keyword) 20.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 13.2.1, B
- strict and lax 5.2
- JSON_ARRAY_T PL/SQL object type 22
- json_arrayagg SQL/JSON function 21.6
- json_array SQL/JSON function 21.4
- json_dataguide SQL function 20.3, 20.4
- as an aggregate function 20.10
- hierarchical format 20.13
- pretty-print format 20.13
- JSON_ELEMENT_T PL/SQL object type 22
- json_equal Oracle SQL condition
- json_exists SQL/JSON condition 15
- JSON_KEY_LIST PL/SQL object type 22
- json_mergepatch() PL/SQL object-type method 9
- json_mergepatch SQL function 9
- JSON_OBJECT_T PL/SQL object type 22
- json_objectagg SQL/JSON function 21.5
- json_object SQL/JSON function 21.3
- json_query SQL/JSON function 17
- JSON_SCALAR_T PL/SQL object type 22
- json_serialize Oracle SQL function 19
- json_table SQL/JSON function 18
- EXISTS
keyword 18
- FORMAT
JSON keywords 18.2
- generalizes other SQL/JSON functions and conditions 18.3
- indexing for queries 26.5
- NESTED PATH clause
18.4
- PATH
clause 18
- json_textcontains SQL/JSON condition 26.9
- json_value SQL/JSON function 16
- as json_table 16.4
- data type considerations for indexing 26.7
- function-based indexing 26.4
- indexing for json_exists
queries 26.6
- indexing for json_table queries 26.5
- null JSON value 16.2
- returning an object-type
instance 16.3
- JSON data guide 20
- JSON generation functions 21
- JSON object types, PL/SQL
- JSON Schema 20
- JSON search index 26.9
K
- key, JSON object
- keywords
L
- lax JSON syntax 5.2
- length() item method, SQL/JSON path expressions 13.3
- like_regex filter predicate, SQL/JSON path expressions 13.2.1
- like filter predicate, SQL/JSON path expressions 13.2.1
- limitations, Oracle Database support for JSON A
- loading JSON data into the database 9
- lower() item method, SQL/JSON path expressions 13.3
M
- materialized view of JSON data 18.5
- MISSING DATA clause, ON MISMATCH clause, json_value 14.5
- multiple data guides for the same JSON column 20.10
N
- NESTED clause, instead of json_table 18.1
- NESTED PATH clause, json_table 18.4
- null handling, SQL/JSON generation functions 21.1, 21.2
- NULL-handling clause, SQL/JSON generation functions 21.1
- NULL ON EMPTY clause, SQL/JSON query functions 14.4
- NULL ON MISMATCH clause, json_value 14.5
- NULL ON NULL, SQL/JSON generation functions 21.1
- number() item method, SQL/JSON path expressions 13.3
- numberOnly() item method, SQL/JSON path expressions 13.3
- numeric-range indexing 26.9
O
- o:frequency data-guide field 20.4
- o:hidden data-guide field 20.8
- o:high_value data-guide field 20.4
- o:last_analyzed data-guide field 20.4
- o:length data-guide field 20.4
- o:low_value data-guide field 20.4
- o:num_nulls data-guide field 20.4
- o:path data-guide field 20.4
- o:preferred_column_name data-guide field 20.4
- object, Javascript and JSON 2.2
- object literal, Javascript 2.2
- object member, JSON 2.2
- object step, SQL/JSON path expressions 13.2.1
- ON EMPTY clause, SQL/JSON query functions 14.4
- oneOf data-guide field (JSON Schema keyword) 20.4
- ON MISMATCH clause, json_value 14.5
- Oracle SQL conditions
- See also: SQL/JSON conditions
- Oracle SQL functions
- json_dataguide 20.3, 20.4
- as an aggregate function 20.10
- hierarchical format 20.13
- pretty-print format 20.13
- json_mergepatch 9
- json_serialize 19
- Oracle support for JSON in the database A
P
- parent COLUMNS clause, json_table SQL/JSON function 18.2
- parsing of JSON data to PL/SQL object types 22
- PASSING clause, json_exists 15
- PATH clause, json_table 18
- path expression, SQL/JSON 13, 13.1
- performance tuning 25
- PL/SQL functions
- PL/SQL object-type methods 22
- PL/SQL object types
- PL/SQL procedures
- PRETTY, package DBMS_JSON 20.7.1, 20.12, 20.13
- PRETTY keyword, SQL functions 14.1
- pretty-printing
- projecting virtual columns from JSON fields 20.8
- properties data-guide field (JSON Schema keyword) 20.4
- property, JSON object
- put() method, PL/SQL object types 22
Q
- queries, dot notation 12
- use with json_table SQL/JSON
function 18
R
- range specification, array 13.2.1
- rawtohex SQL function, for insert or update with BLOB JSON column 3
- relative path expression 13.2.1
- rename_column, DBMS_JSON PL/SQL procedure 20.4
- rendering of JSON data 14.1
- restrictions, Oracle Database support for JSON A
- RETURNING clause
- SQL/JSON generation functions 21.1
- SQL query functions 14.1
- row source, JSON
S
- scalar, SQL/JSON path
expressions
- scalar value, JSON 2.2
- schema, JSON 20
- SDO_GEOMETRY 24
- searching JSON data 26.9
- SELECT statement, NESTED clause instead of json_table 18.1
- serialization
- of JSON data from queries 14.1
- of JSON data in PL/SQL object types 22
- serializing JSON data 19
- setting values in PL/SQL object types 22
- sharding, data-guide information in index 20.2
- sibling COLUMNS clauses, json_table SQL/JSON
function 18.2
- simple dot-notation access to JSON data 12
- use with json_table SQL/JSON
function 18
- Simple Oracle Document Access (SODA) 1
- simplified syntax
- See: simple dot-notation access to JSON data
- size() item method, SQL/JSON path expressions 13.3
- SODA 1
- spatial JSON data 24
- SQL/JSON conditions
- See also: Oracle SQL conditions
- is (not) json 5
- is json
- is not json
- json_exists 15
- json_textcontains 26.9
- SQL/JSON functions
- for generating JSON 21
- for querying 1.1
- json_array 21.4
- json_arrayagg 21.6
- json_object 21.3
- json_objectagg 21.5
- json_query 17
- json_table 18
- json_value 16
- as json_table 16.4
- function-based indexing 24, 26.4
- null JSON value 16.2
- returning an
object-type instance 16.3
- SQL/JSON generation functions 21, 21.1
- SQL/JSON path expression 13, 13.1
- comparison, types 13.5
- item methods 13.3
- syntax 13.2
- array
step B
- basic 13.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 13.2.2
- scalar B
- variable B
- SQL/JSON query functions 1.1
- WITH WRAPPER keywords 14.2
- SQL/JSON variable 13.2.1
- SQL functions
- json_dataguide 20.3, 20.4
- as an aggregate function 20.10
- hierarchical format 20.13
- pretty-print format 20.13
- json_mergepatch 9
- SQL NESTED clause, instead of json_table 18.1
- starts with filter predicate, SQL/JSON path expressions 13.2.1
- step, SQL/JSON path expressions 13.2.1
- storing and managing JSON data, overview 3
- strict JSON syntax 5.2
- STRICT keyword
- is (not) json SQL/JSON condition 5.3
- SQL/JSON generation functions 21.1
- string() item method, SQL/JSON path expressions 13.3
- stringOnly() item method, SQL/JSON path expressions 13.3
- support for JSON, Oracle Database A
- syntax diagrams, basic SQL/JSON path expression B
T
- time and date formats, ISO 8601 13.4
- timestamp() item method, SQL/JSON path expressions 13.3
- tree-like representation of JSON data 22
- trigger for data-guide changes 20.9
- TRUNCATE keyword, Oracle extension for SQL/JSON VARCHAR2 return
value 18
- TRUNCATE keyword, Oracle extension for SQL VARCHAR2
return value 14.1
- type() item method, SQL/JSON path expressions 13.3
- type data-guide field (JSON Schema keyword) 20.4
- TYPE ERROR clause, ON MISMATCH clause, json_value 14.5
U
- UNCONDITIONAL keyword, SQL/JSON query functions 14.2
- unique field names in JSON objects 5.1
- updating JSON data 9
- upper() item method, SQL/JSON path expressions 13.3
- USER_JSON_COLUMNS view 4.1
- USER_JSON_DATAGUIDE_FIELDS view 20.5
- USER_JSON_DATAGUIDES view 20.5
- user-defined data-guide change trigger 20.9.1
V
- value, JSON 2.2
- variable, SQL/JSON path expressions 13.2.1
- view
- create based on a data guide 20.7.1
- create based on data guide-enabled index and a path 20.7.2
- create using SQL/JSON function json_table 18.5
- views
- ALL_JSON_COLUMNS 4.1
- ALL_JSON_DATAGUIDE_FIELDS 20.5
- ALL_JSON_DATAGUIDES 20.5
- DBA_JSON_COLUMNS 4.1
- DBA_JSON_DATAGUIDE_FIELDS 20.5
- DBA_JSON_DATAGUIDES 20.5
- USER_JSON_COLUMNS 4.1
- USER_JSON_DATAGUIDE_FIELDS 20.5
- USER_JSON_DATAGUIDES 20.5
- virtual columns for JSON fields, adding 20.8
- based on a data guide-enabled search index 20.8.2
- based on a hierarchical data guide 20.8.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 14.2
- wrapper clause, SQL/JSON query functions 14.2
- WRAPPER keyword, SQL/JSON query functions 14.2
X
- XML
- compared with JSON 2.3
- DOM 22
Back to main content