So for these reasons (and maybe a few more) Oracle Database 12c supports JSON natively with relational database features, including transactions, indexing, declarative querying, and views. … You can also query, from within the database, JSON data that is stored outside the database, in an external table.

Does Oracle database support JSON?

Oracle Database supports JSON natively with relational database features, including transactions, indexing, declarative querying, and views.

Is JSON a constraint in Oracle?

You can create a table that has JSON columns. You use SQL condition is json as a check constraint to ensure that data inserted into a column is (well-formed) JSON data. Oracle recommends that you always use an is_json check constraint when you create a column intended for JSON data.