Example of After Insert Trigger in Oracle

Question

Please help me........ Prakash.

Shankar M · Answer

Hi Prakash , Assume that You are Inserting a record from Table EMP to Table EMP1. The After Insert Trigger Should be coded as, CREATE TRIGGER INSERT_EMP AFTER INSERT ON EMP FOR EACH ROW BEGIN INSERT INTO EMP1 (EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO) VALUES(:NEW.EMPNO,:NEW.ENAME,:NEW.JOB,:NEW.MGR, :NEW.HIREDATE,:NEW.SAL,:NEW.COMM,:NEW.DEPTNO); END; Here :NEW.EMPNO is the EMPNO value that is inserted in the EMP Table.

Manish Dwivedi · Answer

Suppose we have table Employer which has following columns Id , Name, Phone etc. We can define insert trigger like that CREATE OR REPLACE TRIGGER employerInsert AFTER INSERT | ON Employer FOR EACH ROW DECLARE empName varchar2(10); BEGIN -- Find username of person performing the INSERT into the table SELECT user INTO empName FROM dual; -- Insert record into audit table INSERT INTO empHistory ( empId, Phone, username ) VALUES ( :new.id, :new.phone, empName ); END;

Example of After Insert Trigger in Oracle

Answers (2)