| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: UPDATE Results
Thank you. This worked great!!
-----Original Message-----
Sent: Tuesday, May 21, 2002 12:45 PM
To: Multiple recipients of list ORACLE-L
using sql%rowcount innediately after update statement will give you that value.
Raj
QOTD: Any clod can have facts, but having an opinion is an art!
-----Original Message-----
Sent: Tuesday, May 21, 2002 1:27 PM
To: Multiple recipients of list ORACLE-L
Is there a way to access 'something' that would denote if any rows were
updated?
Feedback lets you set up how many rows will be effected before a count is
returned, but WHERE is this number coming from?
I have found a 'Returning' clause of the update statement, but I don't
really want a value returned, just how many rows were affected.
We have a situation where we want to know if an update statement actually
updated any rows or in fact did not find a row that met the condition.
SqlPlus will return '0 rows updated.' Does anyone know where 0 is coming
from?
Thanks you for your help.
Laura
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Burton, Laura L.
INET: BurtonL_at_prismplus.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 21 2002 - 13:00:51 CDT
 |
 |