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