JSON: Where We Came From, Where We Are, and Where We're Going

Session Number: 8287
Track: Database
Sub-Categorization: DB Dev
Session Type: Tips, Techniques and Tuning
Primary Presenter: Roger Troller [Senior Consultant - Finnova AG bankware]
Time: Jun 26, 2019 (02:15 PM - 03:15 PM)
Room: 619, Level 6

Speaker Bio: Roger Troller is developer/architect living in Switzerland. He has been using SQL and PL/SQL since 1998. He taught SQL and PL/SQL from 2000 to 2016 in Switzerland, Germany and Austria for Trivadis AG. Today he is working for a software development company. He specializes in solving problems with SQL, making use of the enormous features whenever possible.
Technologies or Products Used: SQL, PL/SQL

Session Summary for Attendees:  When JSON first popped up in ORACLE 12, we already had a wide set of functionality for dealing with JSON. Oracle 18 and Oracle 19 evolved this to an even higher level. So, the question is, where are we today? What is already here, what came with the latest release of Oracle (19c), and what is still missing? What should we use JSON for, and when (and why) should we stick to XML?