Make your PL/SQL Pop with SODA
Track
Development & Middleware
Date and time
Friday, 15. October 2021., 11:20
Room
Hall C
Duration
45'
Simple Oracle Document Access (SODA) introduced a PL/SQL API for interacting directly with SODA JSON collections and documents in 18c. This opens an avenue towards a NoSQL approach for certain data. In this talk we will explore how to use SODA from PL/SQL and will also touch on other APIs for Oracle SODA.Topics to be covered will include:- understanding the SODA environment - documents and collections- getting started: enabling and setting up your SODA environment- creating SODA document collections with PL/SQL- inserting, updating and deleting from document collections- searching SODA document collections with PL/SQL using keys and filters- indexing SODA documents- using RESTful web service calls to access and manipulate SODA documents
Lecture details
About speaker
Niall Mc Phillips, author
Niall Mc Phillips has been developing using Oracle since 1989, has been using Oracle PL/SQL Web technologies since 1995 and Oracle APEX since 2005.Niall has developed a number of large, multilingual applications for multinational companies and organisations all over the world. He is a strong believer in APEX and PL/SQL solutions because of their stability, scalability, and rapid development speed.Niall is an Oracle ACE and is the organiser of the Swiss APEX Meetup group and, in the past, has presented at conferences on different sublects including the use of APEX with Oracle Multimedia, Oracle Text, and also on his experiences with the implementation of large Oracle APEX projects.
The Best Sponsor
Educational Sponsor
Media Sponsor
HrOUG.hr
The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.