Loop alll the years, months records and match the code from another table
then retrive the data with the sum of calculation.
I could use agrigate stage to sum up but how do I loop it so, it will hold the values just like a cursor in pl/sql.
In simple way how to do a nested loop in...
Hi, New to PL/SQL and trying to write a scripts which calculate the elapsetime from different metric. I need to join two tables table1 and table2. Table1 has 240 rows and most of the metrics are coming from that table. Table2 has about 200000 rows, and only one column is used against this table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.