How can I determine if an element or value exists in JSON data with Oracle SQL?

Learn how the JSON EXISTS function can help you verify the existence of an element or value with Oracle SQL.

By Darryl Hurley
March 30, 2017

In order to utilize data, SQL developers often need to selectively query data in a JSON table using SQL. In this video, Darryl Hurley explains how to quickly determine if a key or value exists in your JSON data using the JSON_EXISTS function. Beginners to Oracle SQL and JSON will be able to:

  • Use the JSON_EXISTS function.
  • Understand how to validate keys and values.
  • Explain how JSON data is parsed in SQL.
  • Translate key-value pairs into tabular rows and columns.

Sign up for Safari and get 10 days of free access to more SQL and JSON training.

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

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, and is the author of the O’Reilly title Learning Oracle PL/SQL.

Post topics: Software Engineering
Post tags: Questions

Get the O’Reilly Radar Trends to Watch newsletter