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: Do we always have to update or insert? Why can't we just relate?

Re: Do we always have to update or insert? Why can't we just relate?

From: BTDT <dcressey_at_detma.org>
Date: 17 Oct 2005 11:42:16 -0700
Message-ID: <1129574536.326201.173990@f14g2000cwb.googlegroups.com> 





I don't think you understood Marshall's suggestion.



M isn't saying it should insert a duplicate row.  He's just saying that
it's unnecessary to report an error, if the row to be inserted is
already there.  No action is necessary.  No insertion, because
inserting would be an error.   No error flag, because the row you
wanted in the table is (already)  in the table.
Received on Mon Oct 17 2005 - 13:42:16 CDT












Original text of this message













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