Re: Merge Problem

Most of the transactions 96% will be update transactions, so shouldn't we go ahead and try to update first, and then if it is not there do the insert?

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

So I need to replace dup_val_on_index with some other exception. Do you know what that exception is?

Mike Received on Thu Mar 24 2005 - 10:57:25 CST