Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: question about plsql exceptions
stefanomnn_at_yahoo.it wrote:
> Hi! thank u for your answere!
> my aim is making N insert, in a cyvle (while or for)...
> but i have to ignore primary key violated errors (then, if an item is
> present, no problem)
> i didn't find a predefined exception, then i made so:
[snip]
On supported Oracle versions (not stated), you can use the more efficient merge into statement.
-- Regards, Frank van Bortel Top-posting is one way to shut me up...Received on Sat Feb 25 2006 - 06:36:35 CST