{ JSON_expr.JSONExtractValue | JSON_expr.JSONExtractLargeValue } (JSONPath_expr)
Syntax Elements
-
JSON_expr
- An expression that evaluates to a JSON data type.
-
JSONPath_expr
- An expression to extract information about a particular portion of a JSON instance.
- The retrieved data can be any portion of a JSON instance; for example, a name/value pair, object, array, array element, or a value, as long as the returnable part is a scalar value such as a string, number, boolean, or null.
- The JSONPath expression must be in JSONPath syntax.
-
JSONPath_expr cannot be NULL. If the expression is NULL, an error is reported.