counting rows in all_tables ???????

Hello,

i got a smaal problem but don't know how to start.

P.

I want to make a query which count all the rows in each table that ALL_TABLES returns.

so the following result wiil occur:

Table_name                      Number_rows

AA_DEFINED_USERS    11
AA_MODULES                 12
AA_AUTO_BATCH           8

Problely this will be easy but i'm not that good at SQL

PLEASE HELP ERIK OOSTERLING Received on Wed Jul 23 1997 - 00:00:00 CDT