Select Count off tables.

How can I do this.

For example

If you firstly
select distinct table_name from all_tab_columns where owner = 'SYS'

You will return x number of rows

Including

     USER_TABLES
      USER_SOURCE

I want to have a query (PLSQL or SQL) where you can return the above record (most likely into a cursor) and the have another sql that does the following

Select count(*), first_table_returned
from first_table_returned;

then select count(*), second_table_name_returned from second_table_name_retuned;

etc, etc

So that you would get the following output (from the above example)

32,USER_TABLES
343,USER_SOURCE etc, etc

Any Ideas? Received on Thu Jul 26 2001 - 20:58:58 CDT