PL/SQL: getting table counts for multiple tables

[Timothy Chen Allen]

I'm trying to write a PL/SQL procedure to return the count of all the tables my user owns. I have tried this:

declare
  tab_cnt integer;
  cursor my_tables is select table_name from user_tables;
begin
  for rw in my_tables loop
    select count(*) into tab_cnt from rw.table_name;
    dbms_output.put_line(tab_cnt);
  end loop;
end;

but get the following error:

select count(*) into tab_cnt from rw.table_name;
                                      *
ERROR at line 6:
ORA-06550: line 6, column 39:
PLS-00201: identifier 'RW.TABLE_NAME' must be declared
ORA-06550: line 6, column 5:
PL/SQL: SQL Statement ignored

How should I go about this? Thanks in advance.

[Mark Spritzler]

Well unfortunately you cannot use a variable in the from clause in a select statement like you have.
However, you can have a string variable that you concatenate the query to the value of the table name of the current record in your cursor. Then take the string and use the dynamic query package to run the query for you.
Mark