JSON documents can be stored using a VARCHAR2, CLOB, or BLOB column.
Oracle Database 12c introduces a new family of API’s, called Simple Oracle Document Access (SODA). SODA was designed from the ground up to support schemaless application development.
Initially, two implementations of SODA will be available:
? SODA for Java is a programmatic document-store interface for Java developers. Applications based on SODA for Java use SQL*NET to communicate with the database.
? SODA for REST is a REST-based document-store interface, implemented as a Java servlet and delivered as part of Oracle Rest Data Services (ORDS) 3.0. Applications based on SODA for REST use HTTP to communicate with the Java Servlet. The SODA for REST Servlet can also be run under the database’s native HTTP Server.