Trigger to copy new insert record form one table to multiple tables
I am new to oracle trigger, and would like to create a trigger on table EMP (EMP_ID, Pro_ID, EMP_Dep, FName, LName) which will copy only the EMP_ID, Pro_ID, EMP_Dep values from EMP table to another
EMP1 (EMP_ID, Pro_ID, EMP_Dep, Col1, Col2, Col3),
EMP2(EMP_ID, Pro_ID, EMP_Dep, Col4, Col5, Col6),
EMP3(EMP_ID, Pro_ID, EMP_Dep, Col7, Col8, Col9)
tables whenever a new record is created in the EMP table.
Can someone help me with this.
Vishal