Re: Existence Of Data
From: Gary Myers <101355.3556_at_CompuServe.COM>
Date: 1995/12/07
Message-ID: <4a7ggk$c4e$1_at_mhafc.production.compuserve.com>#1/1
Date: 1995/12/07
Message-ID: <4a7ggk$c4e$1_at_mhafc.production.compuserve.com>#1/1
Depending on how many updates to inserts there might be, and the language your SQL is in (SQL*PLUS, FORMS, Embedded Pro* etc) you could try the update first, and if no rows are updated, then perform the insert. If you are going to do a select first, then select the ROWID from the table and do the update keyed on that, which will save Oracle from needing to relocate the row based on the keys.
-- Gary Myers, Analyst/Programmer, Kaisha Technology, West of EnglandReceived on Thu Dec 07 1995 - 00:00:00 CET