Re: %rowcount on select into statements
Date: Thu, 26 Jun 2008 21:31:14 +0200
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
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 DBAReceived on Thu Jun 26 2008 - 14:31:14 CDT