Skip to Main Content

JSON in Oracle Database Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

March 12

18:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Updating JSON data
JSON (JavaScript Object Notation) has become the dominant data exchange format of the 21st century. As of version 12.1, Oracle Database offers powerful, flexible features for storing and manipulating documents. We'll help you modernize your database development with JSON through our sessions on AskTOM Office Hours.

In this AskTOM Office Hours session, Beda Hammerschmidt and Josh Spiegel explore ways to update JSON documents stored in Oracle Database, focusing on JSON_Mergepatch and PL/SQL APIs.

Your Experts

Beda Hammerschmidt
Beda Hammerschmidt, Consulting Member of Technical Staff    
Beda is a developer (and self-proclaimed developer advocate) in the JSON team. Ask him anything JSON.
Blaine Carter
Blaine Carter, Developer Advocate for Open Source    
Blaine started programming in 1995. For most of his career, he used Oracle software to build applications, including Oracle Forms and Oracle Reports, Java, and a whole lot of SQL and PL/SQL. Now he applies his exploratory eye and tinkering inclinations to the intersection of open source software and Oracle Database.


Hi Beda, What is the added value of JSON_SERIALIZE(expr) compared to JSON_QUERY(expr, '$')? Are there significant differences in the actual code executed underneath? Thanks in advance, Stew Ashton

Hi Stew,

JSON_QUERY with path expression '$' is almost equivalent to JSON_ Show more.

Answered by Beda Hammerschmidt -