display number of rows affected in test window

[jroberts]

Hi,

is it possible to display the number of rows affected by an update through the test window? E.g. in the status line

 

[Marco Kalter]

This is currently not possible, but I have added it to the list of enhancement requests.

 

[Marco Kalter]

The following will already do the trick:

begin
  update yourtable
     set ...
   where ...;
  :rows_affected := sql%rowcount;
end;

You can declare :rows_affected as a number or string variable.