Re: PL SQL <table_name> , count(*)

Build a procedure like this

1. Main Loop to extract table_name by a select on ALL_TABLES/USER_TABLES ( with a where clause to filter what you want )
2. Build an Analyze command with the table_name
3. Exec the command via EXEC IMMEDIATE....
4. Extract the table_name,num_rows from the ALL_TABLES / USER_TABLES updated by the previous command

bye
"Matt Gross" <mg_redd_at_hotmail.com_NO_SPAM> wrote in message news:9vna6g$2fso$1_at_nwall2.odn.ne.jp...
> I would like to create a pl/sql script which gives me a list of all tables
> and then gives me a count of all rows for each table. Does anyone know
how
> to do this?
>
> Thanks,
>
> Matt
>
>
Received on Tue Dec 18 2001 - 08:03:24 CST