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
Dev Live Dev Intro

This month we are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Header container

November 12

17:00 UTC   Start Times Around the World

JSON path expressions and syntax simplification
In this session we focus on new features in SQL/JSON path expressions, how they're internally evaluated and how the result is mapped from the SQL/JOSN domain to the SQL domain.
We also give examples for the syntax simplification that we have done for various operators.

2:00 - 6:30 simplified syntax, internal processing and result serialization
6:30 - 14:00 trailing functions
14:00 - 22:00 simplified syntax on SQL expression, use of TREAT AS JSON
22:00 - 28:00 trailing functions for SQL/JSON operators
28:00 - 43:00 use of path predicates in SQL/JSON operators, meaning of [*]
rewrite of multiple operators to JSON_TABLE
43:00 - 46:00 simplified syntax for JSON generation
46:00 - end questions

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


Your Experts
Beda Hammerschmidt
Beda Hammerschmidt, Consulting Member of Technical Staff    
Beda is the brains and fingers behind XML and JSON support in Oracle Database.
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.