I have a sql file with triggers in it. That file has about 30-40 triggers. The insert statement into the update delete table is contained in each trigger. It happens from time to time.
insert into update_delete(id,value,name) values (:old.id,:old.value,:old.name);
or
insert into update_delete(id,value,name)values(:old.id,:old.value,null);
or
insert into update_delete(id,name)values(:old.id,:old.name);
I'd want to develop a script that analyses all the triggers in a sql file and checks to see if the name field in the update delete table is populated with old.name or null. I found some examples here but still need some help. Please advise on how I should go with this.