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 - 05:23:47 CST