Top 60 Oracle Blogs

Recent comments

Create your Oracle test data using JSON and PLSQL

For a long time the only way to create a generator using the testdata_ninja package, was using a pure text
based syntax. It was using special characters and was maybe a bit obscure and not user friendly. The reason for this
was that the databases I needed this package on, was running Oracle 10 and 11. So I needed the package to be compatible
with those versions, and JSON is not supported natively. Looking at the requirements, it would be a good fit for JSON
though. So recently when I needed to run this on Oracle version 12, I had the chance to finally add JSON support. It makes
it a lot more easy to write the generator definitions, as you can see in the below examples.