Re: Adding changed records

From: Daniel Roy <danielroy10_at_hotmail.com>
Date: 6 May 2003 08:32:50 -0700
Message-ID: <1b061893.0305060732.7b755d5e@posting.google.com>

If you're on 9i, you could use the new MERGE command (read about it in the SQL reference manual on tahiti.oracle.com). Otherwise, I would do it with a simple trigger.

Daniel

"Randy Harris" <randy.harris_at_nospam.net> wrote in message news:<5iEta.4179$3f7.3486286_at_newssvr28.news.prodigy.com>...
> Is there a simple means, with either SQL*Plus or SQL*Loader, to UPDATE
> records if they exist but INSERT if they do not?
Received on Tue May 06 2003 - 10:32:50 CDT