Re: Please help with Sequences and Triggers
From: Joseph Mak <jhbmak_at_yahoo.com>
Date: Thu, 14 Dec 2000 10:14:28 -0800
Message-ID: <588_5.131$v1.27041_at_news.pacbell.net>
Date: Thu, 14 Dec 2000 10:14:28 -0800
Message-ID: <588_5.131$v1.27041_at_news.pacbell.net>
Thank you!
Joe
"Jochen Pege" <pege_at_kespretlang.de> wrote in message
news:91aagc$uha$1_at_news10.roka.net...
> This defenitly works:
>
> Create sequence seq_xxx increment by 1;
>
>
> CREATE OR REPLACE TRIGGER [Trigger Name]
> BEFORE
> INSERT
> ON [Table Name]
> REFERENCING OLD AS OLD NEW AS NEW
> FOR EACH ROW
> declare
> v_NewID number;
>
> begin
> select seq_xxx.nextval into v_NewID from dual;
>
> :new.ID := v_NewID;
>
> end;
> /
>
>
> Jochen
Received on Thu Dec 14 2000 - 19:14:28 CET