What does soda have to do with PL/SQL and Oracle Database? Not much...but SODA. Ah, there we have a different story to tell. SODA stands for "Simple Oracle Document Access." It's a set of NoSQL-style APIs that let you create and store collections of documents (most importantly JSON) in Oracle Database, retrieve them, and query them, without needing to know SQL or how the documents are stored in the database. Read lots more about SODA here . As of Oracle Database 18c, we offer SODA APIs for Java , C , Node.js (JavaScript), Python , REST and PL/SQL . I published an article on SODA for PL/SQL in Oracle Magazine; in this blog post, I focus on some highlights. Please do read the full article (and others still to come!). Also, Tim Hall of Oracle-BASE offers his usual outstanding treatment of this topic here . SODA for PL/SQL? Whatever for? First and most important, why would a database developer who writes PL/SQL want to avoid SQL and pretend that t...
For the last twenty years, I have managed to transform an obsession with PL/SQL into a paying job. How cool is that?