Re: # of rows affected by a SQL statement

From: Huberto Kusters <Huberto.Kusters_at_abp.nl>
Date: Thu, 24 Feb 2000 14:58:02 +0100
Message-ID: <893dde$h5r4@abp.nl>

Hi,

This can be done via a bit of PL/SQL

begin

update table set column1='somthing' where column2='somthingelse'; dbms_output.put_line(sql%rowcount); end;

Regards,

Huberto
<jdefreitas7176_at_my-deja.com> schreef in berichtnieuws 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:58:02 CST