Welcome to Oracle Communities
Register and Participate in Oracle's online communities. Learn from thousand of experts, get answers to your questions and share knowledge with peers.
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