Use DBMS_RANDOM to generate text and date values

Numbers, text strings, and dates are three common datatypes used in tables. Although you would expect the PL/SQL package DBMS_RANDOM to be able to generate random numbers—and it does—it is also capable of generating random text and date values as well.

The article continues at http://builder.com.com/5100-6388_14-6068749.html?tag=sc