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.
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.
SODA, the set of APIs specifically designed to support schemaless application development.
There are 2 SODA implementations:
Check out the oracle/json-in-db repository on Github. You'll find downloadable and installable demonstrations for the JSON capabilities of Oracle Database 22.214.171.124.0 and later.
And get more details about Oracle as a Document Store from OTN.
Join the ORDS discussion space on the OTN Community Platform here.
Ciao for Now!