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!

how to find number of rows in a table

malarkandyApr 25 2007 — edited Apr 26 2007

i have one table ,it contains millions of record,how can i know number of rows in that table without using count(*),
i tried in user_table ,for the column NUM_ROWS,but it is not showing number of rows,pls send me a solution for this.

regards,

singh

Locked Post

New comments cannot be posted to this locked post.

Locked on May 24 2007

Added on Apr 25 2007

20 comments

1,285 views