There's a lot to talk about when it comes to JSON support in Oracle Database 12c. A big part of that story is Oracle REST Data Services. But there's more to it. Oracle 12c has a key set of API's: Simple Oracle Document Access (SODA). And it's important.
Here's the deal:
Oracle Database 18.104.22.168 supports storing, indexing and querying JSON documents in the database. But the picture is completed by document-centric API's for accessing JSON documents.
Introducing Simple Oracle Document Access (SODA)
SODA, the set of APIs specifically designed to support schemaless application development.
There are 2 SODA implementations:
SODA for Java-- a programmatic document-store interface for Java Developers that uses JDBC to communicate with the database. SODA for Java consists of a set of simple classes that represent a database, a document collection and a document. Methods on these classes provide all the functionality required to manage and query collections and work with JSON documents stored in an Oracle Database.
SODA for REST-- 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. HTTP verbs such as PUT, POST, GET, and DELETE map to operations over JSON documents. Because SODA for REST can be invoked from any programming or scripting language that is capable of making HTTP calls, it can be used with all modern development environments and frameworks.