The following table describes the JSON functions supported by the current OceanBase Database version.
| 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_TABLE | Converts JSON data to a two-dimensional table. |
| JSON_EQUAL | Determines whether two JSON texts have the same content. |
| JSON_MERGEPATCH | Combines two JSON texts and replaces duplicate key values. |