The following table describes the JSON functions supported by the current version of OceanBase Database.
| Function name | Description |
|---|---|
| JSON_ARRAY | Creates a JSON array. |
| JSON_OBJECT | Creates a JSON object. |
| JSON_ARRAYAGG | Creates an aggregate function for a JSON array. |
| JSON_OBJECTAGG | Creates an aggregate function for a JSON object. |
| JSON_VALUE | Extracts the value of a JSON text in a specified path. Generally, this function returns a scalar value. The default return value is a VARCHAR2(4000) value or a user-specified value. |
| JSON_QUERY | Extracts the value of a JSON text in a specified path. This function can return an array or an object. The default return value type depends on the input data type. If the input data type is VARCHAR, the default return value type is VARCHAR. If the input data type is JSON, the default return value type is JSON. |
| JSON_EXISTS | Determines whether the field in the specified path of the JSON text exists or meets specific conditions. |
| JSON_MERGEPATCH | Combines two JSON texts and replaces duplicate key values. |
| JSON_EQUAL | Determines whether two JSON texts have the same content. |
| IS JSON | Determines whether the text is valid JSON data. |
| JSON_TABLE | Converts JSON data to a two‑dimensional table. |