Re: How to avoid appending matching records ?
Date: Thu, 16 Apr 1992 13:45:25 GMT
Message-ID: <1992Apr16.134525.25906_at_cbnews.cb.att.com>
In article <1992Apr16.011759.6548_at_cbnews.cb.att.com>, lvc_at_cbnews.cb.att.com (Larry Cipriani) writes:
> I have two tables A and B which share a common schema.
> In that schema I have 60 fields, f1, f2, ... f60.
>
> Basically, I want to append A - B to A, but I want the
Oops, that should say, B - A not A - B.
> difference to operate only on two fields f1, and f2. From
> what I can tell, 'MINUS' operates on entire records.
>
> Or ...
>
> If I have a unique index i_a on fields f1 and f2 of A and
> then insert all of B into A the whole insert will fail if
> there is one record from B that matches an indexed record
> in A. Is there a way to make sqlplus keep going and ignore
> the duplicate indexes errors ? That is, inserts on other
> records should succeed but the duplicates should be thrown
> away ?
-- Larry Cipriani, att!cbvox1!lvc or lvc_at_cbvox1.att.com "Be wary of strong drink. It can make you shoot at tax collectors - and miss." -- Lazarus LongReceived on Thu Apr 16 1992 - 15:45:25 CEST