Re: number of rows in a table

Hi!

Here's the answer to the question:

select max(rownum) from tablename;

Hope this helps.

Bye
ais Anjum wrote in message <7sve9o$nqc$1_at_nnrp1.deja.com>...
>Hello
>
>How do I find the number of rows in a table without using the count(*)
>query. I though that num_rows column in user_tables (and a few other
>views) is meant for the job, but when I query this view, it gives me
>a null for all tables.
>With this behavior of num_rows, another question that comes into my mind
>is that what purpose does this column serve? I checked out the comments
>on this column which do say that it should return the number of rows in
>a table...
>
>Confused
>Owais
>
>
>--
>Owais Anjum
>Senior Software Engineer
>Kaps Computing, Pakistan
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Oct 01 1999 - 00:16:38 CDT