Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Merge Problem
"mike" <hillmw_at_charter.net> a écrit dans le message de
news:1111683445.671427.146550_at_o13g2000cwo.googlegroups.com...
| 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
|
Your the one that knows the application. Of course you should first try what is the most mikely to come. The exception name is NO_DATA_FOUND.
Regards
Michel Cadot
Received on Thu Mar 24 2005 - 11:39:17 CST