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

Import JSON Data with SQL Developer Web into Autonomous Database

Twitter Activity provides loads of information for analysis. You can learn your target audience better, determine the most popular content, check the right time when your visitors are more active, etc. By getting the Twitter Activity data and putting it into the advanced analytical systems, you can correlate that data with other essential information from different sources. The prospects are tremendous.

In this article, we’ll explore the case of importing the Twitter data with the help of SQL Developer Web into an Autonomous Database. The imported Twitter dataset is in JSON format. Thus, you’ll need to work on how to import JSON data into Autonomous Database.

CodingSight - Import JSON Data with SQL Developer Web & Autonomous Database
Read More