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 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








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers