RE: Generate RANDOM number

Hi,

The one I am using is:

SELECT dbms_random.value(1000000000000001,9999999999999999) FROM   dual;

any other recommendations???

Thanks
Muqthar

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Muqthar Ahmed Sent: Tuesday, January 04, 2005 2:08 PM
To: 'oracle-l_at_freelists.org'
Subject: Generate RANDOM number

Hi,  

I have to generate 16 digit random numbers.......any recommendations. I am using Oracle 9.2.x release.  

Thanks
Muqthar Ahmed
Oracle9i Certified DBA  

• * * * * * * * *

The information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please reply to the sender and delete it from your computer. T hank you.

--

http://www.freelists.org/webpage/oracle-l

• * * * * * * * *

The information contained in this E-mail message is privileged, confidential, and may be protected from disclosure; please be aware that any other use, printing, copying, disclosure or dissemination of this communication may be subject to legal restriction or sanction. If you think that you have received this E-mail message in error, please reply to the sender and delete it from your computer. T hank you.
--

http://www.freelists.org/webpage/oracle-l Received on Tue Jan 04 2005 - 13:39:03 CST