Re: Random numbers

This is somewhat an Oracle8 plug, but a built-in PL/SQL random number generator will be available in 8.0.3. The package will be called DBMS_RANDOM.

                                Rick
                                Rick Wessman
				Security Products
                                Network and Management Products
                                Oracle Corporation
                                rwessman_at_us.oracle.com

Aric LeDell <aledell_at_targetsite.com> writes:

> 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
>
> Yes, I was able to put together a psuedo-random integer generator.
> The algorithm comes from the excellent book:
> 'Numerical Recipies in C', Press, et.al., p 284.
>
> Please contact me at aledell_at_targetsite.com if you wish to use
> the source code.
>
> -Aric
 

--