How to get RANDOM number?

From: Violin <violin.hsiao_at_mail.pouchen.com.tw>
Date: 9 Jun 1999 00:56:16 GMT
Message-ID: <375fbc07.2441252@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 Tue Jun 08 1999 - 19:56:16 CDT