CREATE OR REPLACE TRIGGER tri_emp_sequence
BEFORE INSERT ON example
FOR EACH ROW WHEN (new.id is null OR new.id=0)
BEGIN
select emp_sequence.nextval into :new.id from sys.dual;
END;
BEFORE INSERT ON example
FOR EACH ROW WHEN (new.id is null OR new.id=0)
BEGIN
select emp_sequence.nextval into :new.id from sys.dual;
END;