RE: Number of affected rows?

Hi Gyula,

You can use cursor attribute SQL%ROWCOUNT

Something like this:

declare

        ...
begin

	update your_table
	set ....
	where ...;
	if  sql%rowcount > 0 then
		do_somewhat_you_like;
	end if;

the same way for deletes

Ed

>
> Hi Gurus,
>
> Is there any way to get the a number of affected rows after
> an update or delete statement?
>
> Thanks in advance
> Gyula Andor
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Andor Gyula
> INET: gy.andor_at_euromacc.hu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Fri Oct 27 2000 - 04:04:33 CDT