Oracle Magazine, March/April 2019
Database Developer PL SQL SODA APIs are available for Java C REST Python Node js and PL SQL This article explores the basic concepts behind SODA as exposed through the SODA API for PL SQL Links at the end of the article provide more details on SODA generally and on JSON OVERVIEW All of the SODA APIs share the same concepts and flow First because the point of SODA is to relieve a developer of the need to know SQL the APIs are not tablefocused but are instead document centric Use a SODA API to manage create read update delete documents of just about any kind including videos images and most commonly JSON Documents are organized into collections You can have one collection for all your documents you can create a collection for each type of document my video collection my song collection and so on or you can create collections for different components ORACLE MAGAZINE MARCH APRIL 2019 83 of your application You can query the contents of documents by using pattern matching query byexample or document keys You might be wondering why anyone who writes PL SQL would be interested in avoiding SQL and instead opt for a SODA API Most back end database developers will of course stick to the normal way of using PL SQL as a way to enhance the SQL language and provide additional security and as a means of implementing business logic In large enterprises that have Oracle Database installed however more and more front end and or full stack developers want to work with document databases With the wide array of SODA APIs now available for Oracle Database they can have the best of both worlds the power and security of the worlds best rela
You must have JavaScript enabled to view digital editions.