1. JSON Developer's Guide
  2. Appendixes
  3. Diagrams for Basic SQL/JSON Path Expression Syntax

C Diagrams for Basic SQL/JSON Path Expression Syntax

Syntax diagrams and corresponding Backus-Naur Form (BNF) syntax descriptions are presented for the basic SQL/JSON path expression syntax.

The basic syntax of SQL/JSON path expression is explained in Basic SQL/JSON Path Expression Syntax. This topic recapitulates that information in the form of syntax diagrams and BNF descriptions.

Figure C-1 json_basic_path_expression

Description of Figure C-1 follows
Description of "Figure C-1 json_basic_path_expression"

Figure C-2 json_absolute_path_expression

Description of Figure C-2 follows
Description of "Figure C-2 json_absolute_path_expression"

Figure C-3 json_nonfunction_steps

Description of Figure C-3 follows
Description of "Figure C-3 json_nonfunction_steps"

Figure C-4 json_object_step

Description of Figure C-4 follows
Description of "Figure C-4 json_object_step"

Figure C-5 json_field_name

Description of Figure C-5 follows
Description of "Figure C-5 json_field_name"

Figure C-6 json_array_step

Description of Figure C-6 follows
Description of "Figure C-6 json_array_step"

Figure C-7 json_array_index

Description of Figure C-7 follows
Description of "Figure C-7 json_array_index"

Array indexing is zero-based, so integer is a non-negative integer (0, 1, 2, 3,...).

The array index form last + integer is only for use with Oracle SQL function json_transform, and you cannot use it in combination with other indexes, including in a range specification (a json_array_step of the form json_array_index to json_array_index).

Figure C-8 json_function_step

Description of Figure C-8 follows
Description of "Figure C-8 json_function_step"

Figure C-9 json_item_method

Description of Figure C-9 follows
Description of "Figure C-9 json_item_method"

Figure C-10 json_filter_expr

Description of Figure C-10 follows
Description of "Figure C-10 json_filter_expr"

Figure C-11 json_cond

Description of Figure C-11 follows
Description of "Figure C-11 json_cond"

Figure C-12 json_conjunction

Description of Figure C-12 follows
Description of "Figure C-12 json_conjunction"

Figure C-13 json_comparison

Description of Figure C-13 follows
Description of "Figure C-13 json_comparison"

Figure C-14 json_relative_path-expr

Description of Figure C-14 follows
Description of "Figure C-14 json_relative_path-expr"

Figure C-15 json_compare_pred

Description of Figure C-15 follows
Description of "Figure C-15 json_compare_pred"

Figure C-16 json_var

Description of Figure C-16 follows
Description of "Figure C-16 json_var"

Figure C-17 json_scalar

Description of Figure C-17 follows
Description of "Figure C-17 json_scalar"

Note:

json_number is a JSON number: a decimal numeral, possibly signed and possibly including a decimal exponent.

See Also:

Related Topics

Parent topic: Appendixes