Re: %rowcount on select into statements

From: <>
Date: Thu, 26 Jun 2008 21:31:14 +0200
Message-ID: <>

On Thu, 26 Jun 2008 20:46:13 +0200, "buu" <> wrote:

>How could I find how many records has been passed by some select statement?
>for example, I have an select like:
>select sum(count(*) )
> into retval
> from table1
> where field1='1'
> group by field2, field3
> having count(*)>1;
>so, I would like to have some like %RowCount attribute to find how many
>records this query have passed. (notice that there are aggregate functions
>and grouping).
>, search for rowcount. You will find SQL%rowcount.
Please avoid asking questions here if you didn't search the documentation first.

Sybrand Bakker
Senior Oracle DBA
Received on Thu Jun 26 2008 - 14:31:14 CDT

Original text of this message