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

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

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