Developer (Dev) and DBA (Ops) together must build a new web application for the recently-acquired coffee shops chain
- Oracle DB 12c as JSON document store.
JSON supported by all Oracle features
- Parallel SQL
How is JSON stored?
- No special data type for JSON. It can be VARCHAR2, BLOB or CLOB.
- Add CONSTRAINT checks could validate the input document.
SQL> CREATE TABLE orders(order_details BLOB
CHECK (order_details IS JSON) );
Native SQL support for JSON