MERGE Command

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