Re: Random Number

There's a package called DBMS_RANDOM which generates random numbers. The file is called dbmsrand.sql and is located in $ORACLE_HOME/rdbms/admin (Unix) or $ORACLE_HOME\rdbms\admin (NT).

"Arslan" <lara0_at_caramail.com> writes:

> Hello,
> I am using Oracle 8.0.6 and i dont know how to generate a random number
> in a SQL query.
>
> Thanks you for your help.
>
>
>
 

-- 
                                        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.