CREATE OR REPLACE TRIGGER EMPLOYEE_ROW_ID_TRIGGER BEFORE INSERT ON EMPLOYEE FOR EACH ROW DECLARE seq_no number(12); BEGIN select EMPLOYEE_ID_SEQ.nextval into seq_no from dual ; :new EMPLOYEE_ID :=seq_no; END; SHOW ERRORS;
If you insert a row in a table, then create another table and then say Rollback. In this case will the row be inserted?