Use DBMS_RANDOM to generate text and date values
May 9, 2006[From Builder.com]
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 numbersand it doesit 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