Re: Total rows in table

From: Gary Waldrom <garyw_at_amonra-insight.com>
Date: Mon, 3 Jan 2000 12:08:11 -0000
Message-ID: <E47927FC0A9CD3119D090000216DAFF50228E7@THOTH>

You will only get the total number of rows the last time the table was ANALYZEd by using the SELECT NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='MY_TABLE'; method, it is not accurate for the current table

Gary Waldrom
Amonra Insight Ltd.
Authors of Q-file IT Quick Reference Guides http://www.q-file.com

-----Original Message-----
From: Alex Vinokur [mailto:alexander.vinokur_at_telrad.co.il] Posted At: Monday, January 03, 2000 11:24 AM Posted To: server
Conversation: Total rows in table
Subject: Total rows in table

Using the following SQL command

SELECT count (*) FROM MY_TABLE; we can get number of rows in MY_TABLE.

Question. Is there another way to get this number? I tried to use the SQL command :

SELECT NUM_ROWS FROM USER_TABLES WHERE TABLE_NAME='MY_TABLE'; However, what I obtained is not number of rows in MY_TABLE.

        Thanks in advance,
        Alex

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 03 2000 - 06:08:11 CST