Re: Is there any RANDOM functions in PL/SQL?

None. It doesn't exist in 7.3. You can get an alternative solution from the website of Thomas Kyte,
http://osi.oracle.com/~tkyte

Hth,

--
Sybrand Bakker, Oracle DBA
Rexx <nebacar_nospam_at_eunet.yu> wrote in message news:85mva9$hic$1_at_SOLAIR2.EUnet.yu...
> What script create DBMS_RANDOM package (and other usefull DBMS packages)
fro
> Oracle 7.3 on NT?
>
> --
> *********************************************
> Remove nospam from address
>
> nebacar_at_eunet.yu
> *****************************************
>
> fumi <fumi_at_tpts5.seed.net.tw> wrote in message
> news:85aa98$1kc$2_at_news.seed.net.tw...
> >
> > Weidong Zhou <weidong.zhou_at_sabre.com> wrote in message
> news:38767482.761F244E_at_sabre.com...
> > > Daniel,
> > > I found something about random number on Internet. Oracle has
> DBMS_RANDOM
> > > package that can generate random number. I also found a simple sample
> code
> > > as follows:
> > >
> > > DECLARE
> > > i BINARY_INTEGER;
> > > BEGIN
> > > dbms_random.initialize(19254);
> > > i := dbms_random.random;
> > > INSERT INTO some_table VALUES(i);
> > > dbms_random.terminate;
> > > END;
> > >
> > > The problem is when I run the the code, I got some errors like
> > > ORA-06550: line 4, column 5:
> > > PLS-00201: identifier 'DBMS_RANDOM.INITIALIZE' must be declared
> > >
> > > I am not a DBA, so I wonder how do I run DBMS_RANDOM package? Anyone
has
> > > ideas? Thanks.
> >
> >
> > DBMS_RANDOM package is not created in a default installation.
> > You may ask your DBA to create it and grant the execution privilege to
> you.
> >
> >
> >
> >
> >
> >
>
>
>
>
Received on Fri Jan 14 2000 - 05:46:53 CST