How do I query for specific JSON elements using Oracle SQL?

Learn how to use the JSON_QUERY function to look for specific JSON elements using Oracle SQL.

By Darryl Hurley

March 30, 2017

Screen from "How do I query for specific JSON elements using Oracle SQL?" (source: O'Reilly)

Developers often need to parse data in JSON format and assemble it for further processing. In this video, Darryl Hurley demonstrates how values can be extracted from JSON data using SQL’s native query abilities. Beginner Oracle SQL developers will learn how to:

Use the JSON_QUERY function.
Extract a key value as JSON-formatted text.
Translate key-value pairs into tabular rows and columns.

Learn faster. Dig deeper. See farther.

Join the O'Reilly online learning platform. Get a free trial today and find answers on the fly, or master something new and useful.

Learn more

Continue learning Oracle SQL in our Oracle SQL and JSON course.

Darryl Hurley specializes in Oracle database administration and PL/SQL programming, and is a senior level database engineer with Change Healthcare. He has used SQL with Oracle since Oracle version 5, and speaks at Oracle User Group conferences. Darryl blogs at implestrat.com, and is the author of the O’Reilly title Learning Oracle PL/SQL.

Post topics: Software Engineering

Post tags: Questions