Q:

Oracle trigger update on two tables

My question is: is it possible to create trigger for update operation which handles update operation on two tables. These tables would be defined after ON statement in TRIGGER definition.

A:

No, it's not possible to put two tables in the ON clause in a trigger. But you can create two triggers, one for each table. You can also create an updatable view with an INSTEAD OF trigger, as @Littlefoot suggests. 

