Re: Random numbers (PL/SQL Package attached)

From: Chrysalis <cellis_at_iol.ie>
Date: 1997/04/14
Message-ID: <33529E41.3365_at_iol.ie>#1/1

This is a multi-part message in MIME format.

--------------4BF17C5AD7C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Nadav Zin wrote:
>
> I need to generate random numbers in Oracle environment and could not
> find a straight forward way to do it. Has anyone got a PL/SQL code to
> share?
>
> Cheers,
>
> Please reply to: N.Zin_at_cs.ucl.ac.uk

I attach a PL/SQL package which I use. It seems to stand up to all the usual tests.
(If attachments are a problem, I will mail it to anyone inline, but I do not want to post the whole thing as a single message)

Hope this helps.

Chrysalis.

--------------4BF17C5AD7C
Content-Type: multipart/appledouble; boundary="----------ad2A335EE3142E"; x-mac-type="54455854"; x-mac-creator="522A6368"; name="random.pkg"
Content-Transfer-Encoding: 7bit
Content-Description: BBEdit Lite 3.5 Document
Content-Disposition: inline; filename="random.pkg"

------------ad2A335EE3142E

Content-Type: application/applefile
Content-Transfer-Encoding: base64

<encoded_portion_removed>
QkJTVAAAAB4D7f//AAAAAAHeTVQAgP//AAAATAHeTeQ=

------------ad2A335EE3142E
Content-Type: text/plain; name="random.pkg"
Content-Transfer-Encoding: base64
Content-Disposition: inline; filename="random.pkg"

<encoded_portion_removed>
YWNrYWdlIGJvZHkgUkFORE9NOw0N

------------ad2A335EE3142E--

--------------4BF17C5AD7C-- Received on Mon Apr 14 1997 - 00:00:00 CEST