Pulling rownum from Oracle

[jritchie]

I am trying to get the total number of records in a table on an Oracle 8i db. I can "select max(rownum) from tablename", but I am unsure how to display this number. and use this number again.

Please help.

[hkucsis]

Try

"select count (*) as numOfRows from tablename"

then treat numOfRows as a normal database field