Re: generate random numbers

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 3 May 2005 06:24:38 -0700
Message-ID: <1115126678.787929.97010@o13g2000cwo.googlegroups.com>

To expand on Jim's reply dbms_random has several randon value generator options including

dbms_randon.randon integers in the range of negative 2 raised to the 31 power to positive 2 raised to the 31

dbms_randon.value numbers in the range of 0 to 1

dbms_randon.string random character strings

As Jim pointed out why would you want to write your own when Oracle has provided such rich functionality for you.

HTH -- Mark D Powell -- Received on Tue May 03 2005 - 08:24:38 CDT