Re: Total rows in table

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 03 Jan 2000 16:31:05 -0500
Message-ID: <k7527s0duaj5ho4o4aujpo3almc6ffvf5b@4ax.com>

A copy of this was sent to "Kathinka Diehl" <kathinka_at_rrr.de> (if that email address didn't require changing) On Mon, 3 Jan 2000 13:50:40 +0100, you wrote:

>
>Thomas Kyte <tkyte_at_us.oracle.com> schrieb:
>>
>> counting the rows with count() is the way to get the row count if you
>really
>> really need it.
>
>How about "select max(rownum) from TABLE"?
>

that'll work -- obscure but it'll work. does about the same amount of work as count(*) would in general.

>Regards
>Kathinka
>

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Jan 03 2000 - 15:31:05 CST