RE: Generate RANDOM number
- From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
- To: <Muqthar.Ahmed@xxxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 4 Jan 2005 15:13:24 -0500
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.
--
//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.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
