Selecting All Rows in a Schema.

[Keek]

skhanal - the schema name is BOB - when I run the statement you gave me using that schema name it prompts me with "Enter value for bob:"

select DECODE(GROUPING(table_name), 1, 'Total',Table_Name)
AS Table_Name, sum(num_rows) from dba_tables
where owner=&BOB
group by rollup (table_name);

I'm not sure what to enter for a value.