Having JSON documents stored in the database is one thing, and knowing how to navigate through the document is another, but extracting the data into a relational format is what it is all about.
This chapter focuses on this transformation, creating a relational output from a JSON document using SQL statements.
The examples in this chapter use the sample data from the previous chapter.
Get Modern Oracle Database Programming: Level Up Your Skill Set to Oracle's Latest and Most Powerful Features in SQL, PL/SQL, and JSON now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
Get Mark Richards’s Software Architecture Patterns ebook to better understand how to design components—and how they should interact.
Dive in for free with a 10-day trial of the O’Reilly learning platform—then explore all the other resources our members count on to build skills and solve problems every day.
Start your free trial Become a member now