Re: Getting Record Count from SELECTs

"GeoPappas" <PappasG_at_gmail.com> wrote:

>Is there any way to get the record count from a SELECT statement
>without having to run another query?
>
>For example, say you have a query as follows:
>
>SELECT * FROM temp WHERE create_date < TO_DATE( '01/01/2005',
>'MM/DD/RRRR' );
>
>Is there any way to get the record count without having to run anothe
>SELECT, such as:
>
>SELECT COUNT(*) FROM temp WHERE create_date < TO_DATE( '01/01/2005',
>'MM/DD/RRRR' );
To do what?

SqlPlus will indicate the count in its feedback.

If you are coding in some language like VB, then create a recordset with the query and then you can get its count without rerunning the query..

. Received on Tue Oct 11 2005 - 11:16:49 CDT