I got a task to calculate the metrics of a program, like to find the no of SELECT and INSERT statement is a program. With that I have to even calculate the tablewise no of SELECT and INSERT statements, I have written the code for finding the no of SELECT and INSERT statements but unable to find tablewise.
Table Statement Occurance Pgm_table SELECT 4 Abc_table INSERT 5
Please help me out with this or anybody can just tell me the logic how to calculate the statements tablewise, it will be a great help. I am trying to write the code in JSP. Please help.
Please help me regarding the above query, its an urgent need
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.