Re: ignore error

From: Eugene Firyago <efiryago_at_bisys.com>
Date: Mon, 24 Jan 2000 11:15:08 -0500
Message-ID: <86htri$4i0$1@bob.news.rcn.net>

With Oracle 8.x you can use deferrable constraints (including PRIMARY KEY). See Oracle 8.x SQL Reference on CONSTRAINT clause and SET CONSTRAINT command.

Jeff <kit_at_cintec.cuhk.edu.hk> wrote in message news:86h4r1$ln$1_at_justice.csc.cuhk.edu.hk...
> Hi,
>
> How do you ignore the unique constraint error when inserting tables from a
> selected results, such that all records are inserted with duplicates
records
> left behind?
>
> Thanks.
>
> Jeff
>
>
Received on Mon Jan 24 2000 - 10:15:08 CST