Interesting...someone clever than I can probably construct a Zen view of the
situation.
Absent that, however, COMMIT and ROLLBACK affect the permanence of changes
caused by SQL statements. 0 rows deleted means nothing changed, so you
could as well commit as roll back and the results should be identical.
Test, though, to be sure!
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-----Original Message-----
Sent: Wednesday, February 14, 2001 1:37 PM
To: Multiple recipients of list ORACLE-L
I'm using transactions, with a delete followed by an insert.
If the delete affects 0 rows, there is nothing to do.
Do I need to rollback the transaction to abandon it, or is everything
the way it should after a delete that affected 0 rows?
Thanks!
-- Sincerely, Fred
Frederik Lindberg, CTO, CheetahMail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Frederik Lindberg
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
