You can get the approximate record count (as of the last analize) from

SELECT TABLE_NAME, NUM_ROWS FROM USER_TABLES

>It was a general question. I don't have a problem with using SELECT (*) FROM TABLE. It is just slow on a table with 650,000 records. I just thought maybe ORACLE had a different/better command to get Record Count from a table.
>
>Thanks