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

November 12, 2019

17: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.

Description

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
Catch up on the recording for our last session!
Don't miss our next live session!
This session: https://asktom.oracle.com/pls/apex/asktom.search?oh=6624

Your Experts

  • #SELECTION#
    Beda Hammerschmidt

    Beda Hammerschmidt   

    Beda is a developer (and self-proclaimed developer advocate) in the JSON team. Ask him anything JSON.
    #MISC#
    #ACTIONS#
  • #SELECTION#
    Blaine Carter

    Blaine Carter   

    As a product manager for Visual Builder, Blaine focuses on helping developers adopt the new Oracle application development platform. For most of his career, Blaine has used Oracle tools to build applications, including Oracle Forms and Oracle Reports, Java, and a whole lot of SQL and PL/SQL. Blaine is borderline obsessed with automating as much as he can. This has drawn him to CI/CD tools and, of course, the cloud. Blaine has a deep love of learning and sharing what he learns with other people.
    #MISC#
    #ACTIONS#

All Sessions

Resources