Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Modifying INSERT

Re: Modifying INSERT

From: Laconic2 <laconic2_at_comcast.net>
Date: Wed, 7 Apr 2004 08:34:38 -0400
Message-ID: <ruOdnQfgdNaraO7dRVn-hw@comcast.com>


You are right. There should be courteous warning.

It could be done with an insert count. The DELETE statement tells you how many rows were deleted, and "zero rows deleted" is a courteous warning that no rows statisfied your cirteria.

Likewise, "zero rows inserted" would be sufficient courteous warning, IMO, that the row was already there. Received on Wed Apr 07 2004 - 07:34:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US