Re: MINUS works, but is there a faster way?

>
>You could try something like this:
>insert into schema2.tablename
>select tablename_pk ,rest of columns from schema1.tablename A
> where not exists (select 'x' from schema2.tablename B
> where B.tablename_pk = A.tablename_pk);
>

You can also sink about this:

insert into schema2.tablename
select tablename_pk ,rest of columns from schema1.tablename A, schema2.tablename B

   where B.tablename_pk= A.tablename_pk(+) AND B.tablename_pk IS NULL Received on Mon Dec 28 1998 - 02:04:57 CST