RE: Generate RANDOM number

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Wed, 5 Jan 2005 09:37:22 -0500
Message-ID: <C9995D8C5E0DDA4A8FF9D68EE666CE0702A971CE@exchsen0a1ma>

Jared,

This is immensely cool. Can we get a link to the resulting seed value for all of our calls to SYS.DBMS_RANDOM?

Tom

-----Original Message-----
From: Muqthar Ahmed [mailto:Muqthar.Ahmed_at_decoratetoday.com] Sent: Wednesday, January 05, 2005 9:29 AM To: 'Ruth Gramolini'; jkstill_at_gmail.com; mwf_at_rsiz.com Cc: ineyman_at_perceptron.com; oracle-l_at_freelists.org Subject: RE: Generate RANDOM number

Hi,

In 10g, it is called DBMS_CRYPTO, where as in Oracle9i, it is DBMS_OBFUSCATION_TOOLKIT. The differences are:

========================== Package Feature DBMS_CRYPTO DBMS_OBFUSCATION_TOOLKIT
========================== Cryptographic pseudo-random number generator RAW, NUMBER, BINARY_INTEGER RAW, VARCHAR2

-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Sent: Wednesday, January 05, 2005 9:04 AM To: jkstill_at_gmail.com; mwf_at_rsiz.com
Cc: ineyman_at_perceptron.com; Muqthar.Ahmed_at_decoratetoday.com; oracle-l_at_freelists.org
Subject: RE: Generate RANDOM number

Even if it doesn't fit his needs, it is imensely cool. RBG

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared Still Sent: Tuesday, January 04, 2005 5:21 PM
To: mwf_at_rsiz.com
Cc: ineyman_at_perceptron.com; Muqthar.Ahmed_at_decoratetoday.com; oracle-l_at_freelists.org
Subject: Re: Generate RANDOM number

On Tue, 4 Jan 2005 17:12:37 -0500, Mark W. Farnham <mwf_at_rsiz.com> wrote:
> You asked what is wrong with his select.
>
> Probably he is seeking information regarding the quality of the pseudo
> random sequence that is generated.

Might this work?

http://www.sciencenews.org/articles/20010512/mathtrek.asp

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
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
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 05 2005 - 08:32:38 CST