Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: "insert or update" in one step?
Jørn,
could you post a link to any documentation on that new command ?
Thanks!
"Jørn Hansen" <joh_at_stibo.dk> schrieb im Newsbeitrag
news:991294031.502630_at_radon.stibo.dk...
> 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 - 05:25:02 CDT