JSON Type Constructor


You can use the JSON data type constructor JSON to parse textual JSON input ( a scalar, object, or array), and return it as an instance of type JSON.

Input values must pass the IS JSON test. Input values that fail the IS JSON test are rejected with a syntax error.

To filter out duplicate input values, you must run the IS JSON (WITH UNIQUE KEYS) check on the textual JSON input before using the JSON constructor.

You can use the constructor JSON only if database initialization parameter compatible is atleast 20.


The input in expr must be a syntactically valid textual representation of type VARCHAR2, CLOB and BLOB. It can also be a literal SQL string. A SQL NULL input value results in a JSON type instance of SQL NULL.