However, as Marco reported from Oracle OpenWorld, native JSON support may be an upcoming new feature in Oracle Database 12c.
This new feature allows the storage of JSON documents in table columns with existing data types like VARCHAR2, CLOB, RAW, BLOB and BFILE.
A new check constraint makes sure only valid JSON is inserted.
For example: CHECK column IS JSON.
New built-in operators allow you to work with stored JSON documents. For example, JSON_VALUE enables you to query JSON data and return the result as a SQL value. Other operators include JSON_QUERY, JSON_EXISTS and JSON_TABLE.
Cool stuff!Comments Off on Native JSON Support in Oracle Database 12c | Filed in Oracle | Tags: 12c, json