Otherwise, the object step does not result in a match. If the JSON object being evaluated contains at least one member, then the object step results in a match to the values of all members. Use the asterisk wildcard symbol ( *) to specify all property names. A complex_name must be enclosed in double quotation marks. A complex_name can contain only alphanumeric characters and spaces, and must begin with an alphanumeric character. Therefore, a match will result only if the alphabetic character cases match in the object step and the JSON data.Ī simple_name can contain only alphanumeric characters and must begin with an alphabetic character. If a member with that property name exists in the JSON object being evaluated, then the object step results in a match to the property value of that member. Use simple_name or complex_name to specify a property name. Object_stepUse this clause to specify an object step. You can use the JSON_value_on_error_clause to override this default behavior. If any step in the path expression does not result in a match, or if the final step matches a nonscalar value, then the function returns null by default. Refer to the JSON_value_returning_clause. You can specify the JSON_value_returning_clause to control the data type and format of the returned SQL value. A path expression that consists of a dollar sign followed by zero steps ( '$') matches the entire context item. If the final step matches a scalar JSON value, then the function returns that value as a SQL value. If the second step results in a match, then the function attempts to match the third step to the JSON value(s) that matched the second step, and so on. If the first step results in a match, then the function attempts to match the second step to the JSON value(s) that matched the first step. The function attempts to match the first step in the path expression to the context item. The dollar sign is followed by zero or more steps, each of which can be an object step or an array step. The path expression must begin with a dollar sign ( $), which represents the context item, that is, the expression specified by expr. The path expression must be a text literal. The function uses the path expression to evaluate expr and find a scalar JSON value that matches, or satisfies, the path expression. Use this clause to specify a JSON path expression. You must specify FORMAT JSON if expr is a column of data type BLOB. If expr is not a text literal of well-formed JSON data using strict or lax syntax, then the function returns null by default. If expr is null, then the function returns null. If expr is a column, then the column must be of data type VARCHAR2, CLOB, or BLOB. For expr, specify an expression that evaluates to a text literal. Use this clause to specify the JSON data to be evaluated. JSON_VALUE finds a specified scalar JSON value in JSON data and returns it as a SQL value. The JSON_VALUE function is available starting with Oracle Database 12 c Release 1 (12.1.0.2).ĭescription of the illustration ''json_value.gif''ĭescription of the illustration ''json_path_expression.gif''ĭescription of the illustration ''object_step.gif''ĭescription of the illustration ''array_step.gif''ĭescription of the illustration ''json_value_returning_clause.gif''ĭescription of the illustration ''json_value_return_type.gif''ĭescription of the illustration ''json_value_on_error_clause.gif''
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |