How many rows affected by UPDATE statement?

[jgotthelf]

Hi,

I'm accessing Oracle via ODBC Passthrough - and after and UPDATE or INSERT I need to find out how many records were

updated. IN SQL Server I do:

update table_name set value = 42 where key_field = 11
select @@rowcount

If the update was successfull, @@rowcount returns a 1, else it returns a zero.

How can I accomplish the same in Oracle?

 

[Guest_imported]

you can use SQL%ROWCOUNT to acheive the same result.

hope this helps,
Jaikish