Top 60 Oracle Blogs

Recent comments

October 2016

Generating random data

We all need to create random data every now and again. Most of the times I have resolved to simply using dbms_random to generate random strings and numbers. The problem with approach though, is that data does not look like "real" data, and indexing will not be realistic. The Alexandria library contains a package that has a few functions random_util_pkg, but it is limited in the type of data you can create, and I felt that there were a couple of more parameters where I needed a bit more control on the output.

So I have created RANDOM_NINJA which for now has the basic functions that I needed.

Just see the quick demo I have created below: