RE: Generate RANDOM number

Igor,

I am looking for DBMS CRYPTO TOOLKIT.

Thanks
Muqthar

-----Original Message-----
From: Igor Neyman [mailto:ineyman@xxxxxxxxxxxxxx] 
Sent: Tuesday, January 04, 2005 3:13 PM
To: Muqthar.Ahmed@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: Generate RANDOM number


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

Igor Neyman, OCP DBA
ineyman@xxxxxxxxxxxxxx



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Muqthar Ahmed
Sent: Tuesday, January 04, 2005 2:39 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Muqthar Ahmed
Sent: Tuesday, January 04, 2005 2:08 PM
To: 'oracle-l@xxxxxxxxxxxxx'
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


* * * * * * * * *

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

Other related posts: