Oracle merge command - missing keyword

Question

I'm trying to use the Oracle MERGE command and am getting an error saying ORA-00905: missing keyword

The query I'm trying is as follows

MERGE INTO vor_extract v USING
(SELECT dealer, wip_no, 
        required_date, required_time 
FROM vor_extract_temp
) t 
ON (v.dealer = t.dealer AND v.wip_no = t.wip_no)
WHEN MATCHED THEN
  UPDATE
  SET v.required_date = t.required_date,
    v.required_time   = t.required_time;

any clues anyone?

It's probably something simple as I've not used the MERGE statement before so am no doubt just missing something

Thanks all

what version of oracle are you using?

Olesya Razuvayevskaya
– Olesya Razuvayevskaya

2014-04-28 10:57:39 +00:00
Commented Apr 28, 2014 at 10:57 — Olesya Razuvayevskaya
– Olesya Razuvayevskaya, Commented Apr 28, 2014 at 10:57
you can see my answer below

CompEng
– CompEng

2014-04-28 11:02:47 +00:00
Commented Apr 28, 2014 at 11:02 — CompEng
– CompEng, Commented Apr 28, 2014 at 11:02

Olesya Razuvayevskaya · Accepted Answer · 2014-04-28 11:07:40Z

3

Generally, the syntax seems valid. But in case you are using oracle versions earlier than 10g, the

 WHEN NOT MATCHED ...

clause is also mandatory

answered Apr 28, 2014 at 11:07

Olesya Razuvayevskaya

1,1681 gold badge8 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2993998 Over a year ago

ah, that will be it then. Yes I am on an old Oracle 9 DB. Thanks a lot for that. I know it would be something simple...

Collectives™ on Stack Overflow

Oracle merge command - missing keyword

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related