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

May 12, 2020

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.

Description

The new update operator JSON_TRANSFORM
So far the set of SQL/JSON operators lacked an operator to specify piece-wise updates. This session gives an introduction on JSON_TRANSFORM which is available in the Oracle Database 20c preview release on Oracle Cloud.

Video Highlights:

1:40 How to get a 20c Preview DB (Blog Post)
5:00 Docs
5:25 JSON Type (recap)
6:00 JSON_Transform: Example
8:45 Demo
10:10 JSON_SERIALIZE
11:40 Update
14:45 Order is not guarenteed
15:15 Update using size()
16:20 Error inserting over existing key (IGNORE ON EXISTING)
21:50 Remove key:value
22:30 Remove ERROR ON MISSING
23:05 JSON_Transform in Select statement
24:15 Inverse of remove
26:00 Calculate a value
32:10 JSON_Transform works on text '{}'
32:55 Use a JSON constructor to create objects
34:20 Array - CREATE ON MISSING
35:30 Complex objects - CREATE ON MISSING not supported
37:40 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=7564

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