Oracle data type JSON

Guarantee of well-formed JSON data

Data that is stored in a column or PL/SQL variable whose data type is json is guaranteed to be well-formed JSON data.

However, it should be kept in mind that Oracle has a lax and a strict JSON format (lax being the default).

Compare with the two predicates is json and is not json.

The init parameter compatible must be set to 20 in order for this datatype to be available.