Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> HOw many records were affected?
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?
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Aug 18 2000 - 11:41:18 CDT