Re: MERGE Command

From: pkl <rc5_at_monochrom.at>
Date: Wed, 07 Jan 2009 22:15:46 +0100
Message-ID: <bdd50$49651bd0$d41158a0$23026_at_news.chello.at>

mrdjmagnet_at_aol.com wrote:
> Been looking all over for this answer:
>
> MERGE INTO x USING DUAL ON (x.c4 = 'A')
> WHEN MATCHED THEN
> INSERT VALUES (0,0,0,'0');
>
> ERROR at line 3:
> ORA-00905: missing keyword
>
> I want to skip the whole "SELECT COUNT(*) blah, blah, blah" to check
> for record existence. A simple MERGE with a MATCHED clause should do
> it. This is an example I'm using.......
>
> What simple thing am I missing?
>

try to read this:
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_9016.htm#sthref9090 Received on Wed Jan 07 2009 - 15:15:46 CST