chitra

• Oct 24th, 2006

 

try to write update/delete/insert trigger on emp2 which will fire on updation/deletion/insertion in emp1

ravi

• 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

hemalatha.bahadur

 Profile Answers by hemalatha.bahadur 

• Jan 7th, 2007

 

write triggers on emp2,so that any updations in emp2 will reflect emp1.
for this we use trigger structure,implement the logic and execute.

rajakumar_na

 Profile Answers by rajakumar_na 

• Nov 19th, 2007

 

i think if any updation made in emp1 it wil not reflect in emp2.bcz table name r difference.

krishnaindia2007

 Profile Answers by krishnaindia2007 

• Jun 22nd, 2008

 

Use triggers to guarantee that when a specific operation is performed, related actions are performed.

sampra

 Profile Answers by sampra 

• Mar 6th, 2012

 

write trigger

aytasirs

 Profile Answers by aytasirs 

• Nov 15th, 2012

 

Use DML Triggers to apply the same action to another table as well.