Re: Merge Problem

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 24 Mar 2005 17:43:41 +0100
Message-ID: <4242edea$0$847$626a14ce@news.free.fr>

"mike" <hillmw_at_charter.net> a écrit dans le message de
news:1111681674.420996.140480_at_z14g2000cwz.googlegroups.com...

| Crap, I have 8.1.7.4.
|
| Any other thoughts about how I might achieve some efficiency doing this
| kind of thing?
|
| Mike
|

PL/SQL. If id is unique (ex. PK):

begin
  Insert into mytable (id, role ) values ( '111111','Super' ); exception when dup_val_on_index then
  UPDATE mytable SET role = 'Super' where id='111111'; end;
/

Regards
Michel Cadot Received on Thu Mar 24 2005 - 10:43:41 CST