Oracle JSON Functions

Oracle JSON() is a built-in function that parses textual JSON input (a scalar, object, or array), and returns it as an instance of type JSON.

Oracle JSON_ARRAY() is a built-in function that takes each input as a JSON value and returns a JSON array containing those JSON values.

Oracle JSON_ARRAYAGG() is a built-in aggregate function that takes SQL expression columns as input, converts each expression to a JSON value, and returns a single JSON array that contains these JSON values.

Oracle JSON_OBJECT() is a built-in function that returns a JSON object containing all the key-value pairs specified by the arguments.

Oracle JSON_OBJECTAGG() is a built-in aggregate function that constructs an object member for each key-value pair and returns a single JSON object containing these object members.

Oracle JSON_QUERY() is a built-in function that is used to select and return one or more values from JSON data. You can use JSON_QUERY to retrieve fragments of a JSON document.

Oracle JSON_TABLE() is a built-in function that creates a relational view of JSON data, converting the JSON data into rows and columns in a table.

Oracle JSON_VALUE() is a built-in function that searches for a specified scalar JSON value in JSON data and returns it as an SQL value.