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: MERGE INTO without WHEN MATCHED, possible?

Re: MERGE INTO without WHEN MATCHED, possible?

From: <gq437x_at_yahoo.de>
Date: 20 Sep 2002 12:38:27 +0200
Message-ID: <lgk7lhymho.fsf@mu.biosolveit.local>


Richard Kuhler <noone_at_nowhere.com> writes:

> I don't see any way to noop the WHEN MATCHED clause. However, won't ...
>
> INSERT ...
> SELECT ...
> WHERE ...
> AND NOT EXISTS ...
>
> do what you want?
>
> Richard

Ouch, of course,
(Volker, takeing of the tomates from his eyes)

Thank you,
Volker

-- 
Volker Apelt                   
Received on Fri Sep 20 2002 - 05:38:27 CDT

Original text of this message

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