Re: Random numbers

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 14 Mar 2002 19:37:50 -0000
Message-ID: <3c910414_2@mk-nntp-1.news.uk.worldonline.com>

"Bill Meng" <marasys_at_televar.com> wrote in message news:3C90E6E2.9763296D_at_televar.com...
> Has anyone generated random numbers with Oracle. How? I'm attempting to
> generate test data using random numbers.
>

Version?
Version?
Version?

Take a look at SYS.DBMS_RANDOM if you're on something current. catoctk.sql will install it (it's in the rdbms/admin directory). If SYS.UTL_RAW isn't already installed you will need utlraw.sql and privtrawb.plb
These scripts should be run connected as SYS.

HTH. Paul Received on Thu Mar 14 2002 - 13:37:50 CST