Re: sql *plus

From: Glenn Baron <gbaron_at_dial.pipex.com>
Date: 21 Oct 1999 11:37:25 GMT
Message-ID: <01bf1bb8$ad793f00$545495c1@default>

How about an extra 'where' or 'and' or 'not exists' that tests for the fk condition that's causing you grief?

Glenn Baron

Larry Pettit <larry.pettit_at_ps.net> wrote in article <PLrP3.263$VF2.14013_at_news.uswest.net>...
> I'm copying data from one table to another using insert/select. The
source
> table may have some bad data and it errors out on a fk constraint in the
> target table. Is there a way in sql *plus to have it not abort totally
but
> continue adding those that pass the test after the bad data?
>
>
>
Received on Thu Oct 21 1999 - 06:37:25 CDT