Make a Backup Of Your Table Information In Database

Copy your Table database into another Table at the same time of Table Input

CREATE OR REPLACE TRIGGER MY_TRIGGER
AFTER INSERT ON EMP FOR EACH ROW

BEGIN

INSERT INTO EMP_COPY -----SECONDARY TABLE
(EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO)
VALUES(:NEW.EMPNO,:NEW.ENAME,:NEW.JOB,:NEW.MGR,HIREDATE,SAL,COMM,DEPTNO);
END;

0 comments: