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

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.value,;


insert into update_delete(id,value,name)values(,:old.value,null);


insert into update_delete(id,name)values(,;

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 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 (630 points) | 602 views

Please log in or register to answer this question.