Get Trigger Name with Column Name
I need to get the name's of the trigger's in which a particular column is being used, either inserted, or updated.
Actually I need to drop certain columns form different tables. So what I have done is that I have created a script which generate the drop script. But what happens is that after dropping the column, when the trigger in triggered and the column that has already been droped, is used in that trigger, I get an error [Column Name] not found.
So I also need to delete those triggers automatically in which a the column I need to delete is being used.
Subject
Written By
Posted
Get Trigger Name with Column Name
February 14, 2011 08:22AM
February 16, 2011 12:27AM
February 21, 2011 03:57AM
February 23, 2011 02:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.