I understand that UPSERT operation either updates or inserts a row into a table (depending if the table already has a row with matching data). Here's the code:
if table t has a row exists that has key X:
update t set mystuff... where mykey=X
else
insert into t mystuff...
But in Oracle, it doesn't have an UPSERT statement. Would would be the best way to do it?
Discuss This Question: