Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: pl/sql dup_val_on_index

Re: pl/sql dup_val_on_index

From: Morff <morff1_at_wp.pl>
Date: Tue, 06 Dec 2005 13:15:20 +0100
Message-ID: <op.s1c2zu1iq0kutt@nt_januszk.herby>


Dnia 06-12-2005 o 13:05:16 nugster <doug.fulton_at_gmail.com> napisał:

> any ideas?
>
> insert into select ... from table1 A

where not exists
(select ... from table1 B where A.field1=B.field1 ..)

?

-- 
Pozdrawiam
Morff
----------------------
AQQ 141151
Powered by Opera/M2
Received on Tue Dec 06 2005 - 06:15:20 CST

Original text of this message

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