tables are, create table ABC (I_NO Number(20), Q_DOC Varchar2(10), QSTN CLOB); create table XYZ (I_NO Number(20), Q_DOC Varchar2(10), QSTN CLOB, ANSWER CLOB, RESULT char(1)); trigger code is, CREATE OR REPLACE TRIGGER A_Z AFTER INSERT OR UPDATE ON ABC FOR EACH ROW BEGIN IF INSERTING THEN INSERT INTO Q_DYN (I_NO, Q_DOC, QSTN) VALUES (:NEW.I_NO, :NEW.Q_DOC, :NEW.QSTN); ELSIF UPDATING THEN UPDATE Q_DYN SET Q_DOC = :NEW.Q_DOC, QSTN= :NEW.QSTN WHERE I_NO = :OLD.I_NO; END IF; END;