Merge - Orcle error

Question

While executing below code, getting error "Missing ON keyword" but I have already written ON clause. Please assist on cause.

merge into emp_temp s

using (select p.employee_id, p.salary, p.last_name,p.email, p.Hire_date, 
p.job_id from employees p
minus 
   select s.employee_id, s.salary, s.last_name,s.email, s.Hire_date, 
s.job_id from emp_temp s    
) EMPLOYEES p

ON (s.employee_id = p.employee_id)

when matched then
 update set s.salary = p.salary

when not matched then
insert 
(s.employee_id , s.salary,s.last_name,s.email,s.Hire_date, s.job_id) 
values
    (p.employee_id, p.salary, p.last_name,p.email, p.Hire_date, p.job_id);

Alex Poole · Accepted Answer · 2015-03-18 12:29:18Z

1

It's coming from this line:

) EMPLOYEES p

You're setting the using clause's alias as EMPLOYEE, but that you're trying to re-alias that as just p. The error doesn't mean that you don't have an ON clause at all, just that it isn't where the parser is expecting to see it.

Since you refer to p later, you just want that single alias:

...
minus 
   select s.employee_id, s.salary, s.last_name,s.email, s.Hire_date, 
s.job_id from emp_temp s    
) p

ON (s.employee_id = p.employee_id)
...

answered Mar 18, 2015 at 12:29

Alex Poole

192k11 gold badges198 silver badges349 bronze badges

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

Collectives™ on Stack Overflow

Merge - Orcle error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related