crazydeveloper
Technical User
hi friends,
pl. help me writing the Trigger while inserting into the table.
the tables look like this,
EMP_Table Finance_Table Marketing_Table
when i am inserting into emp_talbe, columns like this
empid,ename,dname,sal etc.
values(1,'SQL','Finance',1000)
values(2,'SERVER','Marketing',2000)
if dname finance i want to insert the related values into Finance and if it's marketing i want to insert into the Marketing table.
for inserting into 3 tables i want to write a trigger and while inserting i want to check the value of the dname then i want to insert the same into appropiate table.
thanks in advance.
pl. help me writing the Trigger while inserting into the table.
the tables look like this,
EMP_Table Finance_Table Marketing_Table
when i am inserting into emp_talbe, columns like this
empid,ename,dname,sal etc.
values(1,'SQL','Finance',1000)
values(2,'SERVER','Marketing',2000)
if dname finance i want to insert the related values into Finance and if it's marketing i want to insert into the Marketing table.
for inserting into 3 tables i want to write a trigger and while inserting i want to check the value of the dname then i want to insert the same into appropiate table.
thanks in advance.