Re: Select statement

hi,
I think the 2 previous mail don't reply to your request . Am i wrong ?
I think you want the number of rows in each tables ?

You've got a column names NUM_ROWS in the dba_tables. Before using this column, you must submit an "analyze" on all the tables you need
Like that : analyze table my_table compute statistics;

You can also use the proc ANALYZE_SCHEMA from the package DBMS_UTILITY for analyzing all the tables in a schema
(it's faster than declaring all the tables you want) like that :
execute DBMS_UTILITY.ANALYZE_SCHEMA('name_of_your_schema','COMPUTE');

Regards
@nnib

"Luis Fernandes" <lfernandes_at_gruposumol.pt> a écrit dans le message news: 3b26318c.24258632_at_news.telepac.pt...
> How can i do this in Oracle?
>
> select table_name from dba_tables;
>
> and then
>
> select count(*) from ... each table resulting from first select?
>
>
> I'll appreciate your solutions..
>
> lfernandes_at_gruposumol.pt
Received on Tue Jun 12 2001 - 14:14:04 CDT