SQL & PL/SQL

Hi,

I need to implement Change Data Capture using Triggers.

I have the below emp table in source and my target table is emp_target.

CREATE TABLE EMP(EMPNO NUMBER PRIMARY KEY,

                                     ENAME VARCHAR2(10),

                                     SAL NUMBER,

                                     COMM NUMBER,

                                     DEPTNO NUMBER);

and my Target Table is EMP_TARGET as shown below

CREATE TABLE EMP_TARGET(EMP_SURRG NUMBER PRIMARY KEY,

                                                       EMPNO NUMBER,

                                                       ENAME VARCHAR2(10),

                                                       SAL NUMBER,

                                                       COMM NUMBER,

                                                       DEPTNO NUMBER);

Appreciate your help in creating a trigger in implementing CDC using triggers.

Regards,