Re: %rowcount on select into statements

On Thu, 26 Jun 2008 20:46:13 +0200, "buu" <aha_at_a.com> 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).
>
>tnx...
>

http://tahiti.oracle.com, 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