Thanks for the reply guys!

Basically, I need to generate real life looking name address details for volume testing purpose, so, I thought if I keep a table of firstname, lastname, address, city, postcode - then from there I can generate some more realistic data. So, I posted the question.

Definitely, I can handle it using any programming language like VB etc. But I was wondering whether that can be achieved by using PL/SQL only.

One plausible idea seems to be using a PL/SQL function to generate random first and last name and then concatenating them.

The table has around 50,000 rows!