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;
15 years ago
0 comments:
Post a Comment