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