Re: ORACLE - Random Function??

Uwe Schneider <pi_at_nospam.richard-schneider.de> writes:

> Hi Oliver,
>
> Oliver Henlich wrote:
> >
> > Hi!
> > Does anyone know if there is a function to generate a random number in
> > oracle?
>
> creating random numbers is _the_ example for calling external procedures
> (EXTPROC) in the excellent book "Oracle PL/SQL", O'Reilly.
I suggest using the DBMS_RANDOM package instead as it is a lot faster than calling an external procedure.

--

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