CREATE OR REPLACE TRIGGER TR_EXCEPTN BEFORE INSERT ON EXCEPTN FOR EACH ROW DECLARE next_idxinc NUMBER; BEGIN SELECT seq_exceptn.NEXTVAL INTO next_idxinc FROM dual; :new.IDXexcept := next_idxinc; END; seq_exceptn is SEQUENCE IDXexcept is a column of table EXCEPTN
ON EXCEPTN FOR EACH ROW
DECLARE
next_idxinc NUMBER;
BEGIN
SELECT seq_exceptn.NEXTVAL
INTO next_idxinc
FROM dual;
:new.IDXexcept := next_idxinc;
END;
seq_exceptn is SEQUENCE
IDXexcept is a column of table EXCEPTN