Re: random function

How about sequence generator.
Connect to Oracle via sqlplus and type the following commands:

Create sequence seq1
select seq1.nextval from dual

justvrk wrote:

> Check this out...
> http://osi.oracle.com/~tkyte/Misc/Random.html
> HTH,
> justvrk
>
> In article <8ktbh2$hhg$1_at_nnrp1.deja.com>,
> Brian Yan <by999_at_hotmail.com> wrote:
> > Hi there,
> >
> > How to generate a random number in Oracle, I couldn't find a built-in
> > function. Could someone let me know?
> >
> > Thanks,
> >
> > Brian
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jul 25 2000 - 00:00:00 CDT