INSERT or UPDATE

I need a command that works like REPLACE does on MySQL (definition folows). What is the equevalent on oracle?

• Troels

    REPLACE [LOW_PRIORITY | DELAYED]
[INTO] tbl_name [(col_name,...)]
        VALUES (expression,...)
or REPLACE [LOW_PRIORITY | DELAYED]

[INTO] tbl_name [(col_name,...)]
        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 - 05:53:47 CST