Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> # of Rows updated?
Hi,
I am trying to determine, VIA ODBC from VB how many rows are affected by an UPDATE statement, I.E. I send, via pass through:
update table set value=x where key=yy
And I want to know how many rows were affected (1 or 0) - reason for this is to detect dirty reads.
In SQL Server I can "select @@rowcount" - but this does not work in Oracle. Any suggestions on how I can either:
Joe G.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Aug 31 2000 - 21:18:13 CDT