INSERT or UPDATE
From: Try Out <kasse_at_kutte.dk>
Date: Wed, 28 Feb 2001 12:53:47 +0100
Message-ID: <lkpp9t08gmgcmkf0lu4olo6li11rtobca4_at_4ax.com>
Date: Wed, 28 Feb 2001 12:53:47 +0100
Message-ID: <lkpp9t08gmgcmkf0lu4olo6li11rtobca4_at_4ax.com>
I need a command that works like REPLACE does on MySQL (definition
folows). What is the equevalent on oracle?
REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name [(col_name,...)]
[INTO] tbl_name [(col_name,...)]
VALUES (expression,...)
or REPLACE [LOW_PRIORITY | DELAYED]
SELECT ...
or REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name
SET col_name=expression, col_name=expression,...
REPLACE works exactly like INSERT, except that if an old record in the table has the same value as a new record on a unique index, the old record is deleted before the new record is inserted Received on Wed Feb 28 2001 - 12:53:47 CET