Query JSON Data with SQL/JSON Functions & Autonomous Database

In the previous article, we worked on the Twitter Activity dataset in JSON format with the SQL Developer Web tool in Autonomous Database. However, SQL Developer Web has its limitations. It only allows you to parse the first level of the JSON data. Thus, it won’t support parsing complicated JSON structures.

So, does it mean you can’t deal with the data you need properly? Fortunately, there is an alternative. You can use SQL/JSON functions json_value, json_query to build complicated query or use dot-notation to access your JSON data.

CodingSight - Query JSON Data with SQL/JSON Functions & Autonomous Database
Read More