how know the rows effect when using update sql

hi all.
i’m a new member of this forum. i’m italian. sorry for my english.
can I know how many rows I updated, with the command sql update?
when I use
update table set filed = value where keyid = x
in other languages i have the number of rows effect. In Natural?

ps: the tables are oracle.

thank you.

Hi,

I think you should write stored procedure for this.

Please refer following link.

http://stackoverflow.com/questions/1103260/return-number-of-rows-affected-by-update-statements

Regards,
Sreekanth