Friday, July 21, 2017

Quick Tip#3: Storing JSON data in Oracle Database

For the last couple of years, I have used JSON as my go to data format. Many a times, I had to store the JSON in the database. I used the same approach of storing it as a VARCHAR2/CLOB/BLOB and then validating the data via API. Also there was no check on what else could exist in that column(junk value or error insertion) resulting in even more validations for my data.

Now, Oracle has come up with JSON support in databases 12.1.0.2 version, which is really helpful for some one storing the json values in db.

Here is the link to the article, which explains the same in details.


Awesome work, Oracle.  

No comments:

Post a Comment