Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Count the number of rows in each table

666432Jan 12 2010 — edited Nov 4 2010
I have a list of table names, how to I write a query to find out the row count of each table.

select table_name from all_tables a where owner='XXX' and num_row > 100
or
select table_name from all_tables a where owner='XXX' and sample_size > 100


doesn't quite work.
Why?

Thanks in advance,

Edited by: mpt_fz on Jan 12, 2010 12:06 PM
This post has been answered by MichaelS on Jan 13 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 10 2010
Added on Jan 12 2010
10 comments
12,022 views