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!

num_rows from view...

mariasFeb 19 2008 — edited Feb 20 2008
without using count(*) we can get the row count using this.
select aa.owner,aa.table_name,aa.num_rows from all_tables aa;

is there a way to get row count for views without using count(*).
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 19 2008
Added on Feb 19 2008
5 comments
1,391 views