Number of rows updated

I have a block of statements like the following. The last statement in
the block is an update statement. I was wondering if there is a way to
get the number of rows updated by that statement. An easy way would be
to wrap the whole thing in a function but, the code is not mine and it
is difficult to change "legacy" code with the current managers:


DECLARE var_a number;
var_b number;
BEGIN
a bunch of sql statement go here;
update emp_table set bonus = new_rate where dept_num = 'abc';
END;

.

Relevant Pages

  • Re: Updateing a SQL select populated form
    ... what i want to do is, display all the records frm the table, ... If you want the user to be able to change the flg entry, you need an input element; in this case I'd probably use a checkbox. ... Just build your SQL statement (an UPDATE statement) to change the data you want. ...
    (comp.lang.php)
  • Re: Capture Before/After data on Multirow Updates
    ... You can't assign multiple row values to a single variable. ... after data for ALL updated records from the update statement. ... Declare @mval2 nvarchar ...
    (microsoft.public.sqlserver.mseq)
  • Re: How to Use Cursor variable in Where Statement
    ... Do you have example how to do it in BULK operation? ... But why not doing it with just one SQL statement instead of using PL/SQL? ... See update statement in SQL Reference: ...
    (comp.databases.oracle.misc)
  • Re: How to update my access to current date??
    ... I try using the following sql statement.. ... > Syntax error in UPDATE statement. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: How to update my access to current date??
    ... schreef in bericht news:OyLw6GFqEHA.644@tk2msftngp13.phx.gbl... ... I try using the following sql statement.. ... > Syntax error in UPDATE statement. ...
    (microsoft.public.inetserver.asp.general)