i've done below.....

CREATE TRIGGER TRG_TMP

AFTER INSERT OR UPDATE OR DELETE

OF ID or Stud_Name

ON

STUD

BEGIN

--

here i need oracle query to compare the ID, stud_name in two tables,

and i want to update APP table.

END

Please help me...