PL/SQL (MOSC)

MOSC Banner

Trigger to copy new insert record form one table to multiple tables

edited Aug 11, 2011 2:26AM in PL/SQL (MOSC) 4 commentsAnswered
Hi

 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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center