Re: Random Functions with PL/SQL

From: James Petts <jpetts_at_celltech.co.uk>
Date: 1998/01/28
Message-ID: <34CEF71C.2812@celltech.co.uk>#1/1

Brad Orahood wrote:
>
> Does anyone out there have a good reliable random
> number generator that they use in PL/SQL?

You might want to check out Kevin Taufner's package at

http://www.revealnet.com/plsql-pipeline/archives/util.spp

It has a random number genereator that allows you to select either the multiplicative congruential method (approx 2.57E8 results) or the rectangularly distributed statistical method (approx 6.95E12 results). There are MS Turd docs at

http://www.revealnet.com/plsql-pipeline/archives/Util.doc

-- 
James "I'd rather fall off Ilustrada than ride any other horse" Petts

Received on Wed Jan 28 1998 - 00:00:00 CST