Re: select statement

Obviously some people here like to take the long way around ;-))

I'd simply use:

select table_name, count(column_name) from dba_tab_columns where table_name IN
  (select table_name

      from dba_tables ) group by table_name

Remember though that it'll take some time to complete! You could limit the number of tables you get back by adding a where clause on the owner column in dba_tables, so you can look at the tables from a specific user... I think you got the idea...

HTH,

--
Bastiaan Schaap
________________________________
Do not park in a space that says "Reserved for Sheriff's Deputies".


"Luis Fernandes" <lfernandes_at_gruposumol.pt> wrote in message
news:3b263360.24726184_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..

>

>