Re: How to get RANDOM number?

From: Roger Jackson <rjackson_at_wire.net.au>
Date: Wed, 9 Jun 1999 19:40:25 +1000
Message-ID: <7jld6i$pj1$1@caley.wire.net.au>

Violin,

If you are using Oracle 8 you can use the DBMS_RANDOM built in package to generate random numbers.

You can generate random numbers between -9999999999 and 9999999999.

Cheers

Roger.

Violin <violin.hsiao_at_mail.pouchen.com.tw> wrote in message news:375db941.1730548_at_news.twsc.pouchen.com.tw...
> Hello,
> If I have a table
> TEST
> ---------------------------------
> SER_NO NUMBER(5);
> NAME CHAR(20);
>
> I want to create a trigger before insert into TEST,
> and get a random number between 00001 and 99999 for SER_NO.
> CREATE TRIGGER INS_TEST
> BEFORE INSERT ON TEST FOR EACH ROW
> BEGIN
> :new.ser_no := (How to get the random number?)
> END;
> /
>
> Best Regards.
>
> Violin.
> violin.hsiao_at_mail.pouchen.com.tw
Received on Wed Jun 09 1999 - 04:40:25 CDT