Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Exist clause in PL/SQL

Re: Exist clause in PL/SQL

From: DStevens <dstevens_at_navidec.com>
Date: Mon, 12 Nov 2001 12:59:59 -0700
Message-ID: <3BF02A3F.6288F258@navidec.com>


Or
begin
insert into table ...
exception when others then -- catch any error, can also check specifically for just duplicate key violation.
null;
end;

>
Received on Mon Nov 12 2001 - 13:59:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US