List tables with count of rows in Oracle database
Posted on 2009-02-23
I am just the user of a Oracle database. I want to list all table and row count for the database.
select table_name from dba_tables where Owner = 'Owner'
Is there any simple SQL query can pull that information?
If I want to display each columns distinct count , what is the query too.
I want the output look like this:
And column distinct count
TABLEA COLA 12
TABLEA COLB 5
TABLEA COLC 12
TABLEB COLA 15
TABLEB COLB 7
TABLEB COLC 15
TABLEC COLA 40
TABLEC COLB 40
TABLEC COLC 40