number of rows in a table
From: Owais Anjum <owais_anjum_at_my-deja.com>
Date: Thu, 30 Sep 1999 10:33:48 GMT
Message-ID: <7sveac$o1c$1_at_nnrp1.deja.com>
Hello
Date: Thu, 30 Sep 1999 10:33:48 GMT
Message-ID: <7sveac$o1c$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 Thu Sep 30 1999 - 12:33:48 CEST