Re: Getting Record Count from SELECTs

On 11 Oct 2005 08:45:41 -0700, "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' );
Look up the SQL%ROWCOUNT or <cursor_name>.ROWCOUNT attribute in your PL/SQL manual.

--
Sybrand Bakker, Senior Oracle DBA