chitra
Answered On : Oct 24th, 2006
try to write update/delete/insert trigger on emp2 which will fire on updation/deletion/insertion in emp1
Login to rate this answer.
ravi
Answered On : Jan 3rd, 2007
Using Joins we can update the fileds.
use alias names for common fields which r present in Emp1 and Emp2
If Emp1 and Emp2 have common fields namely field1,field2 then:
update E1.field1,E2.field1 from Emp1 E1,Emp2 E2 where E1.field1=E2.field2
Login to rate this answer.
write triggers on emp2,so that any updations in emp2 will reflect emp1.
for this we use trigger structure,implement the logic and execute.
Login to rate this answer.
i think if any updation made in emp1 it wil not reflect in emp2.bcz table name r difference.
Login to rate this answer.
Use triggers to guarantee that when a specific operation is performed, related actions are performed.
Login to rate this answer.
write trigger
Login to rate this answer.
Use DML Triggers to apply the same action to another table as well.
Login to rate this answer.