// PL/SQL Advance // Author: Hamed Farvardin // HR DB Oracle Express Version 11.2.0.2.0 // Chapter 6 - Advance Oracle Schema Objects - TRIGGERS CREATE TABLE test1 (col1 number(5), col2 varchar2(50)); CREATE TABLE test2 (col1 number(5), col2 varchar2(50)); CREATE OR REPLACE TRIGGER test_trg1 AFTER INSERT ON test1 FOR EACH ROW BEGIN insert into test2 values (:new.col1 , :new.col2); END; / SELECT * FROM test1; SELECT * FROM test2; INSERT INTO test1 VALUES (1,'Hello Hameeed!'); CREATE TABLE audit_table (op_time date, col1 number(5), col2_before varchar2(50), col2_after varchar2(50)); CREATE OR REPLACE TRIGGER audit_trg AFTER INSERT OR DELETE OR UPDATE ON test1 FOR EACH ROW BEGIN insert into audit_table values (sysdate, :new.col1 , :old.col2, :new.col2); END; / UPDATE test1 set col2= 'Hello Aliiii !!' where col1 = 1; SELECT * FROM audit_table;