The following table describes the supported JavaScript Object Notation (JSON) functions.
| Function | Description |
|---|---|
JSON_QUERY |
Selects and returns one or more values from JSON data, allowing you to retrieve fragments of a JSON document. |
JSON_TABLE |
Creates a relational view of JSON data by mapping JSON evaluation results into relational rows and columns, allowing queries as a virtual table. Outputs JSON values from objects in a JSON array as individual SQL columns. |
JSON_VALUE |
Finds a specified scalar JSON value in JSON data and returns it as a SQL value. |
JSON_ARRAY |
Converts a sequence of SQL scalar expressions or a collection type instance (VARRAY or NESTED TABLE) into a JSON array containing the corresponding JSON values. |
JSON_ARRAYAGG |
Aggregates a column of SQL expressions, converts each to a JSON value, and returns a single JSON array containing those values. |
JSON_OBJECT |
Creates a JSON object from a sequence of key-value pairs or an object type instance, excluding collection types. Returns a JSON object with an object member for each key-value pair. |
JSON_OBJECTAGG |
Aggregates property key-value pairs, typically from SQL columns, and returns a single JSON object containing the corresponding object members. |
JSON_DATAGUIDE |
Aggregates a table column of JSON data, returning a data guide as a CLOB for each JSON document in the column. |