SQL & PL/SQL

I have TRG_B, a trigger associated with Table B, but the trigger references a column in Table B's parent Table, Table A. i.e. a Column in Table B is based on a value in a column in Table A.

So if anything is inserted or updated in Table B, the trigger TRG_B fires and everthing is fine. However, I also need TRG_B to be fired when Table A is updated.

Does anyone have a solution? Can something like this be done?:



CREATE OR REPLACE TRIGGER TRG_A BEFORE Update ON Table_A FOR EACH ROW
begin
for every child record in Table B:
call TRG_B;
end;