Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Random Number
Chaps,
You guys must be psychic, I was just about to post the same question.
Thanks for the answer.
Terry.
Rick Wessman <rwessman_at_us.oracle.com> wrote in message
news:un1obyfob.fsf_at_us.oracle.com...
> 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.
Received on Mon Mar 06 2000 - 00:00:00 CST