Re: "insert or update" in one step?

A copy of this was sent to gdulli_at_zdnetmail.edu (Todd) (if that email address didn't require changing) On 31 May 2001 20:26:11 GMT, you wrote:

> 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)
>>>
>>>
>>
>>

from the Oracle9i new features guide
http://technet.oracle.com/products/oracle9i/content.html ...
To increase the efficiency and reduce time taken to load and refresh critical data warehouses, Oracle9i provides support for external tables, allowing data from external systems to be quickly loaded into the database. In addition, a new data capture facility will allow incremental changes from target sources to be captured and applied to the data warehouse automatically. Other data load capabilities provided to increase data load scalability and reduce complexity include multi table insert and upsert semantics. This new ETL functionality will also be leveraged by Oracle Warehouse Builder. ......

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp