Re: Sequence

CREATE OR REPLACE TRIGGER V BEFORE INSERT ON TEST FOR EACH RAW
DECLARE I INTEGER;
BEGIN  SELECT SEC.NEXTVAL INTO I FROM DUAL;
   :NEW.SECFIELD:=I;
END; ðòéíåòîï ôáë (ÒÁÚ×ÙÅ ÞÔÏ ÎÅÍÎÏÇÏ ÓÉÎÔ ÏÛÉÂÏË )

"Gary Knopp" <gknopp_at_ascend.com> wrote in message news:8743ek$sdp_at_nntpa.cb.lucent.com...
> Is there away to assign a sequence number in a
> a before insert trigger event? I can't seem to get
> this to work properly.
>
> Thanks
>
>
>
Received on Mon Jan 31 2000 - 00:00:00 CET