17 SQL/JSON Path Expressions

Oracle AI Database provides SQL access to JSON data using SQL/JSON path expressions.

• Overview of SQL/JSON Path Expressions
  Oracle AI Database provides SQL access to JSON data using SQL/JSON path expressions.
• SQL/JSON Path Expression Syntax
  SQL/JSON path expressions are matched by SQL/JSON functions or conditions against JSON data, to select or test portions of it. Path expressions can use wildcards and array ranges. Matching is case-sensitive.
• SQL/JSON Path Expression Item Methods
  The Oracle item methods available for a SQL/JSON path expression are presented. How they act on targeted JSON data is described in general terms and for each item method.
• Types in Filter-Condition Comparisons
  Comparisons in SQL/JSON path-expression filter conditions are statically typed at compile time. If the effective types of the operands of a comparison are not known to be the same then an attempt is sometimes made to reconcile them by type-casting.