Re: Simple query question..........................(I hope)

Hi,

I propose you first run a script to create a sql-file, that you then run. To create the script use this select:

spool tab_count.sql
select 'select '''||table_name||''',count(*) from '||table_name||';' from user_tables;
spool off

If you don't want the users own tables, but all tables the user can 'see', you just have to select from all_tables instead.

After this you just run tab_count.sql

Hope this helps

Regards, Michael Ringbo

Ryan Van Vleet wrote:

> I have an oracle instance with thousands of tables. I need to run a query
> that tells me how many records are in each table and display it so that it
> tells me the table name and number of records in one output file. I am able
> to run a single count on one table wich works fine but I want to get it all
> at with one command.
>
> Any help appreciated or reccomendations on where to post if this isn't the
> right place,
>
> Ryan Van Vleet
Received on Fri Jan 08 1999 - 09:09:13 CET