After Update Trigger SQL

Question

Hey guys i created two tables in oracle sql, first one has 2 columns, and the second has 3 columns(one of them is a foreign key from Pk of first table). I want to create a trigger that AFTER i update the column of the foreign key in second table, will update the other columns according to the value of the pk.

• Table1(idF, name)
• table2(id, idF, name)

I want to create a trigger that when i update idF(foreign key) in table2 will display the same name as in table1.

Answer 1

you can use this after update trigger on table1

delimiter $$
create trigger MyTrigger after update on table1 
for each row
begin
    update table2 set name = new.name where idF = new.idF;
end$$

Answer 2

You can create trigger in oracle as follows:

Create or replace trigger trg_table2
Before update of idf on table2
For each row
When (old.idf <> new.idf and new.idf is not null)
Begin
Select name into :new.name 
  from table1
 Where idf = :new.idf;
End;
/