SODA for PL/SQL
SODA for PL/SQL is a PL/SQL API that implements Simple Oracle Document Access (SODA). You can use it with PL/SQL to perform create, read (retrieve), update, and delete (CRUD) operations on documents of any kind, and you can use it to query JSON documents.
SODA is a set of NoSQL-style APIs that let you create and store collections of documents (in particular JSON) in Oracle Database, retrieve them, and query them, without needing to know Structured Query Language (SQL) or how the documents are stored in the database.
Regardless of the SODA implementation language you use, the general concepts are the same, and much of the reference material is the same. All such common information is in Introduction to Simple Oracle Document Access (SODA). Here are quick links to some of the conceptual material: