This is the default.ĮRROR ON ERROR - Returns the appropriate Oracle error when an error occurs.ĮMPTY ON ERROR - Specifying this clause is equivalent to specifying EMPTY ARRAY ON ERROR.ĮMPTY ARRAY ON ERROR - Returns an empty JSON array ( ) when an error occurs. NULL ON ERROR - Returns null when an error occurs. The function matches a single scalar value or, multiple values of any type, and the WITH WRAPPER clause is not specified The return value data type is not large enough to hold the return character string You can override the behavior for this type of error by specifying the JSON_query_on_empty_clause. No match is found when the JSON data is evaluated using the SQL/JSON path expression. Use this clause to specify the value returned by this function when the following errors occur:Įxpr is not well-formed JSON data using strict or lax JSON syntax You can use the JSON_query_on_error_clause to override this default behavior. If the function returns a single scalar value, or multiple values of any type, and you do not specify WITH WRAPPER, then the function returns null by default. The ARRAY keyword is optional and is provided for semantic clarity. JSONPath Dependencies To use JSONPath, we will need to include its dependency and then use it. JSONPath is used for selecting and extracting a sub-section from the JSON document. If the path expression matches a single JSON object or JSON array, then the array wrapper is omitted. JSONPath is a query language for JSON with features similar to XPath for XML. Specify WITH CONDITIONAL WRAPPER to include the array wrapper only if the path expression matches a single scalar value or multiple values of any type. The UNCONDITIONAL keyword is provided for semantic clarity. Specifying the WITH UNCONDITIONAL WRAPPER clause is equivalent to specifying the WITH WRAPPER clause. You must specify this clause if the path expression matches a single scalar value (a value that is not a JSON object or JSON array) or multiple values of any type. Specify WITH WRAPPER to include the array wrapper. You can specify this clause only if the path expression matches a single JSON object or JSON array. Specify WITHOUT WRAPPER to omit the array wrapper. Use this clause to control whether this function wraps the values matched by the path expression in an array wrapper-that is, encloses the sequence of values in square brackets ( ).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |