Re: # of rows affected by a SQL statement

You can use the implicit SQL cursor that is used by Oracle for anonymous SQL statements like a normal explicit cursor e.g.

delete from mytable;
if sql%rowcount > 10 then
....
end if;

or

update my_table set acolumn = 'x' where acolumn = 'y';

if sql%notfound then
...
end if;

Rich.

jdefreitas7176_at_my-deja.com wrote in message <891asn$8b8$1_at_nnrp1.deja.com>...
>Hi All.
>
>I was wondering if there was a system variable
>in Oracle that would display the number of rows
>affected by a SQL statement. I don't mean rownum;
>I just want to execute an UPDATE, and then see
>how many rows were affected. Thanks!
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Feb 24 2000 - 07:19:38 CST