How to access SODA for PL/SQL is described, as well as how to use it to perform create, read (retrieve), update, and delete (CRUD) operations on collections.

The Simple Oracle Document Access (SODA) functionality was introduced with Oracle REST Data Services (ORDS) against Oracle 12.1, as described here. Oracle 18c introduced a PL/SQL API for interacting directly with SODA collections and documents. This article gives an overview of the Simple Oracle Document Access (SODA) for PL/SQL functionality in Oracle Database 18c.