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

April 14, 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.


JSON Type in Oracle Database 20c (preview release on Oracle Cloud)
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.

Video Highlights:

1:00 - Documentation
1:45 - JSON RFC Comparison
3:55 - Demo 1
4:35 - Allow Scalars (default)
5:25 - Disallow Scalar
6:00 - Check Constraint Disallow Scalar
7:25 - Select JSON_VALUE type
8:15 - JSON Column Type
8:45 - Query example
10:25 - Dump Column Types
11:10 - Text JSON vs BINARY JSON Format
14:35 - JSON type representation requirements
15:45 - JSON Existing Binary Formats
18:25 - Oracle's Binary JSON Format: OSON
20:05 - OSON internals (simplified)
23:40 - Update OSON
25:55 - Many updates OSON
27:20 - JSON Type Constructor
31:20 - JSON Type and Text JSON conversions
33:00 - Demo 2
38:10 - Experiment with JSON and CLOB
39:35 - Question - How are special characters stored CR LF Tab…
44:00 - Performance
46:25 - PL/SQL examples
48:35 - JSON generation
50:00 - Extended type system
51:50 - JSON type in JDBC
52:30 - OracleJsonObject
53:20 - Dictionary Views
53:40 - When to use JSON Type or Text?
55:10 - Questions

Your Experts

    Beda Hammerschmidt

    Beda Hammerschmidt   

    Beda is a developer (and self-proclaimed developer advocate) in the JSON team. Ask him anything JSON.
    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.