Date: Wed, 7 Jan 2009 12:39:34 -0800 (PST)
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? Received on Wed Jan 07 2009 - 14:39:34 CST