SODA for PL/SQL is a PL/SQL API that implements Simple Oracle Document Access (SODA). It is part of Oracle Database — no additional installation is needed.

You can use SODA for 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:

Learn About SODA for PL/SQL Release 21


Learn About SODA for PL/SQL Release 19


Learn About SODA for PL/SQL Release 18