Re: Sequences in Triggers

Thanks, but I actually managed to figure it out right after I sent the message:

CREATE OR REPLACE TRIGGER test_trigger

    BEFORE INSERT ON test_table
FOR EACH ROW
  BEGIN
  select test_seq.nextval into :new.id_nbr from dual ;

  END; Received on Tue Oct 19 1999 - 12:34:59 CDT