Re: Random number function?

xux_at_informa.bio.caltech.edu (Xuequn Xu) writes:

> There is a package called DBMS_RANDOM, provided by Oracle. Maybe it is
> already in your system, just do a "desc DBMS_RANDOM" to find out. If it is
> not already there, you can build it by running the dbmsrand.sql script,
> located in $ORACLE_HOME/rdbms/admin/.
The DBMS_RANDOM package is only available in Oracle8 8.0.4 and higher. For Oracle7 7.3, he will have to use the function provided by Tom Kyte in another posting in this thread.

>
> ------------
> "Robert" Xuequn Xu, Oracle DBA
> Caltech, Pasadena, CA 91125
>
>
> yliu_at_creighton.edu wrote:
> : Hi All,
>
> : I have seen a random number function in this news group before.
> : Unfortunately, I didn't save the random function that time. I was
> : wondering if somebody could post that again or someone of you have another
> : version?
>
> : Thank you in advance for your help.
> : P.S. I am using Oracle 7.3xx.
>
>
> : Yongge Liu
> : yliu_at_creighton.edu
>
>

--

                                        Rick
                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com

       The statements and opinions expressed here are my own and do not
             necessarily represent those of  Oracle Corporation.