Message on Whatsapp 8879355057 for DSA(OA + Interview) + Fullstack Dev Training + 1-1 Personalized Mentoring to get 10+LPA Job
0 like 0 dislike
865 views

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.

in Competitive-Programming by Expert (650 points) | 865 views

Please log in or register to answer this question.