Write Sql syntax to create Oracle Trigger before insert of each row in employee table

Question

If you insert a row in a table, then create another table and then say Rollback. In this case will the row be inserted?

Answer 1

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;