Re: "insert or update" in one step?

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 - 02:30:06 CDT