Relational to JSON With SQL

Oracle started adding JSON support to Oracle Database with version The earliest support was targeted at storing, indexing, and querying JSON data. Version 12.2 rounded out that support by adding features for generating, exploring, and processing JSON data. See the JSON Developer’s Guide for a comprehensive overview of what’s now available. In this post, I’ll leverage the new SQL operators for JSON generation to convert the relational data to meet the goal.

Please Note: This post is part of a series on generating JSON from relational data in Oracle Database. See that post for details on the solution implemented below as well as othe…
DZone Database Zone

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.