JSON in Oracle Database: Resources to Get You Started
JSON in Oracle Database: Resources to Get You Started
This topic is intended to serve as a launch point for your exploration and education on the topic of JSON in Oracle database.
Join the DZone community and get the full member experience.
Join For FreeBuilt by the engineers behind Netezza and the technology behind Amazon Redshift, AnzoGraph™ is a native, Massively Parallel Processing (MPP) distributed Graph OLAP (GOLAP) database that executes queries more than 100x faster than other vendors.
I am (finally) diving in to explore and then write about using JSON in Oracle Database 12c with SQL (Releases 1 and 2) and — more to the point for me — with PL/SQL (based on enhancements in Release 2).
Expect to see posts on my blog, articles in Oracle Magazine, quizzes and workouts at the Oracle Dev Gym, and more in 2018.
To that end, I have been collecting links to useful resources on this topic, and I realized that you might benefit from that list just as much as I will. So why not share it now?
Before exploring Oracle-specific resources, visit json.org to learn more about JSON itself.
Oracle Documentation
Let's start with the official source of truth: our doc set.
First and foremost, we have the Database JSON Developer's Guide, which covers how to store, generate, view, manipulate, manage, search, and query JSON.
And here are some specific links you might find handy:
- Basic SQL/JSON Path Expression Syntax: The basic syntax of a SQL/JSON path expression is presented. It is composed of a context item followed by zero or more object or array steps, depending on the nature of the context item, followed optionally by a function step. Examples are provided.
- JSON Data Guide: This lets you discover information about the structure and content of JSON documents stored in Oracle Database. Easily one of the coolest "added value" features of our implementation of JSON support.
- Using PL/SQL With JSON Data: Explore the new types added in PL/SQL for JSON manipulation, and learn about how best to leverage SQL JSON features in PL/SQL.
Oracle Product Development
LiveSQL Tutorial by Mark Drake, Principal Product Manager
Mark is the PM for XMLDB and for JSON in the database. He has put together a truly fantastic tutorial on LiveSQL that steps you through all the latest features for both SQL and PL/SQL in the 12.2 release. Here are the modules in the tutorial:
This is undoubtedly your best starting point for getting up to speed on JSON in Oracle Database.
Note: You will need to have an Oracle account to access the tutorial.
Top 10 Tips for JSON Processing in Database by Beda Hammerschmidt, Consulting Member of Technical Staff
Beda is the primary developer for JSON features in Oracle Database. So his command of the features is top-notch, and his understanding of JSON goes deep.
This video is long but is well worth the time for anyone wanting to get started right with this feature set.
Beda's blog on JSON, where, as he puts it, "I explain things in small steps." Perfect!
Tim Hall/ORACLE-BASE
Tim Hall is no slouch when it comes to keeping up with the latest in Oracle Database — and offering clear, easy-to-follow articles on new features. JSON is no exception. The following two articles should give you a solid jumpstart on deploying JSON columns and related functionality in your applications.
Darryl Hurley/Implestrat
Darryl's been working with Oracle Database for a couple of decades, with a big focus on SQL and PL/SQL. He's helped me with several of my books and has also written quizzes for Oracle Dev Gym. After encountering resistance by UI developers in his organization to using Oracle Database for JSON-based development, he decided to get up to speed on this functionality — and share what he's learned with the community.
We recently held a CodeTalk session on this topic. Check out the video of our conversation and his demonstrations here.
Darryl is also in the midst of publishing a series of posts regarding JSON on his blog.
And There's More
Here are a number of other links to blog posts, videos, code samples, and more on JSON in Oracle Database.
GitHub Examples by Gerald Venzl, Senior Principal Product Manager, Oracle Corporation
JSON in Motion, an Oracle Magazine article on 12.1 JSON by the ever-informative and ever-entertaining Arup Nanda, Oracle ACE Director
Run with JSON, an Oracle Magazine article on 12.2 JSON by Arup Nanda, Oracle ACE Director
JSON in Oracle Database With Examples, a blog post by Nimish Garg, Oracle ACE Associate
Well, you won't have learned a darned thing about JSON in Oracle Database simply by reading this blog post. But hopefully, it can serve as a launch point for your exploration and education on this topic.
And if you've found some other outstanding content that you think I should add to this post, please let me know!
Download AnzoGraph now and find out for yourself why it is acknowledged as the most complete all-in-one data warehouse for BI style and graph analytics.
Like This Article? Read More From DZone
Published at DZone with permission of Steven Feuerstein , DZone MVB. See the original article here.
Opinions expressed by DZone contributors are their own.
{{ parent.title || parent.header.title}}
{{ parent.tldr }}
{{ parent.linkDescription }}
{{ parent.urlSource.name }}