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 09:40:49 -0700
Message-ID: <3BEFFB91.FCADE571@navidec.com> 





insert into tablea (column list) (select column list from tableb where not
exists (select 1 from tablea where tablea.pk = tableb.pk))



Yaron Avior wrote:



> \

Received on Mon Nov 12 2001 - 10:40:49 CST












Original text of this message













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