RE: Generate RANDOM number

From: Muqthar Ahmed <Muqthar.Ahmed_at_decoratetoday.com>
Date: Tue, 4 Jan 2005 16:22:38 -0500
Message-ID: <6362087FB073D41195B800D0B78284BE098141F0@mail01.corp.abwf.com>

Igor,

I am looking for DBMS CRYPTO TOOLKIT.

Thanks
Muqthar

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

From: Igor Neyman [mailto:ineyman_at_perceptron.com] Sent: Tuesday, January 04, 2005 3:13 PM
To: Muqthar.Ahmed_at_decoratetoday.com; oracle-l_at_freelists.org Subject: RE: Generate RANDOM number

Why do you need other recommendations?
What's wrong with your "select"?

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----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:39 PM
To: 'oracle-l_at_freelists.org'
Subject: 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

* * * * * * * *

* * * * * * * *