Re: Select statement

In article <3b26318c.24258632_at_news.telepac.pt>, lfernandes_at_gruposumol.pt says...

Do you want the total count of all tables:   select count(*)

        from dba_tables

... or the count for each individual table:   select table_name, count(*)

	from dba_tables
	group by table_name

?

• tojo

> 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 - 10:41:07 CDT