Re: Help on Sequence
From: Brian Tkatch <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK>
Date: Fri, 08 Dec 2000 13:30:43 GMT
Message-ID: <3a30e226.1515248421_at_news.alt.net>
Date: Fri, 08 Dec 2000 13:30:43 GMT
Message-ID: <3a30e226.1515248421_at_news.alt.net>
On Fri, 8 Dec 2000 10:44:26 +0700, "Setiawan Wijaya" <swsan_at_flashmail.com> wrote:
>I have a sequence MYTABLE_SEQ and a table MYTABLE(ID Number, Name
>Varchar2(50)).
>How to prevent gaps in my id field when i'm using sequence, because the gaps
>is to big.
>Should I using a trigger?
>
>Setiawan Wijaya
>Application Developer
>
>
This should do it.
CREATE SEQUENCE MyTableSEQ NOCACHE ORDER;
CREATE OR REPLACE TRIGGER MyTableANR
BEFORE INSERT ON MyTable
FOR EACH ROW
BEGIN
SELECT MyTableSEQ.NEXTVAL INTO :NEW.Id From Dual;
END MyTableANR;
/
Brian Received on Fri Dec 08 2000 - 14:30:43 CET