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

Home -> Community -> Usenet -> c.d.o.tools -> Re: "insert or update" in one step?

Re: "insert or update" in one step?

From: Todd <gdulli_at_zdnetmail.edu>
Date: 31 May 2001 20:26:11 GMT
Message-ID: <3b16a8e3$0$1893@news.denver1.Level3.net>

   Are you serious?

In article <991294031.502630_at_radon.stibo.dk>, joh_at_stibo.dk says...
>
>In Orace9i you will have the command 'UPSERT' at your disposal.
>
>/Jørn
>
>"Todd" <gdulli_at_zdnetmail.edu> wrote in message
>news:3b159f56$0$1877_at_news.denver1.Level3.net...
>> Is there a way to do an "insert or update" statement in one step? i.e.
 I
>> want to insert a certain row if it's not there, or else just update it,
 without
>> doing a select first and then branching to either an insert or update.
>>
>> Thanks! - Todd (gdulli_at_zdnetmail.edu - change edu to com)
>>
>>
>
>
Received on Thu May 31 2001 - 15:26:11 CDT

Original text of this message

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