Login or sign up Lost password?
Login or sign up
Rupali select ut.trigger_name, ut.table_owner, ut.table_name 2 from user_triggers ut where trigger_name = 'TRIG_EMP_VIEW' 3 / TRIGGER_NAME TABLE_OWNER TABLE_NAME ------------------------------ ------------------------------ ------------------------------ TRIG_EMP_VIEW KKISHORE EMP_VIEW 1 row selected. it would be (in my opinion) a really utterly truly horrible idea to do what you ask for. I would use a stored procedure that does your processing -- don't try to get magically fancy with a trigger like this.