Oracle Magazine, March/April 2019
Database Developer PL SQL BY STEVEN FEUERSTEIN ORACLE DATABASE SODA and PL SQL Use the SODA API for PL SQL to work with JSON and without SQL in Oracle Database SQL Structured Query Language is the most powerful and widely used language for manipulating data primarily in relational databases such as Oracle Database Its declarative and set oriented approach handles a wide variety of use cases and produces concise elegant ways to both query and change data For some scenarios and some developers however relational data and SQL are not seen as a good fit The flexibility of a JSON document can for example better meet the demands of a rapidly changing schema or one that is poorly defined at the outset of a project For documents in such cases and others Oracle Database offers Simple Oracle Document Access SODA APIs This set of NoSQL not only SQL style APIs enables you to create and store collections of documents in Oracle Database You can retrieve and query them without needing to know SQL or how the documents are stored in the database ORACLE MAGAZINE MARCH APRIL 2019 82
You must have JavaScript enabled to view digital editions.