Getting a variable to be recognized in a loop
I want to write a plsql program that produces a basic report. The report would display the list of all our tables in the datbased followed by their row count.
For example:
Table A 1000
Table B 12
Table C 187
"
etc...
"
Below is the code I used. The main cursor works great but I'm having an issue with this line being executed within the loop:
select count(*) into num_of_rows from table_name_rec.table_name ;
The last part of the above statement "table_name_rec.table_name" isn't being recognized.