i have a table T1 and with two client applications. One application is oracle web application and another is power builder client application.
Is it possible to wite a trigger that set some :NEW values in the row inserted only after the client application inserts or updates a row in the table. I do not want the trigger to fire when web application inserts rows. Can you add WHEN clause using environment variable for name of client.