Merge SQL Statement Will Not Compile

[rebeaj]

Merge SQL statement will not compile. Can anyone help me out?

 Create Or Replace Procedure P_pvt_merge 
As
Begin 
Merge Into Employees2 B
Using (
Select Employee_id, First_name, Last_name, Dept_no, Salary
From Employees
Where Dept_no = 20) E
On (b.employee_id = E.employee_id)
When Matched Then
Update Set B.employee_id = E.employee_id,
B.first_name = E.first_name,
B.last_name = E.last_name,
B.dept_no = E.dept_no,
B.salary = E.salary 
When Not Matched Then
Insert (b.employee_id, B.first_name, B.last_name, B.dept_no, B.salary)
Values (e.employee_id, E.first_name, E.last_name, E.dept_no, E.salary)
Commit;
End;
 

/

[Mishit]

Merge SQL statement will not compile. Can anyone help me out?

 Create Or Replace Procedure P_pvt_merge 
As
Begin 
Merge Into Employees2 B
Using (
Select Employee_id, First_name, Last_name, Dept_no, Salary
From Employees
Where Dept_no = 20) E
On (b.employee_id = E.employee_id)
When Matched Then
Update Set B.employee_id = E.employee_id,
B.first_name = E.first_name,
B.last_name = E.last_name,
B.dept_no = E.dept_no,
B.salary = E.salary 
When Not Matched Then
Insert (b.employee_id, B.first_name, B.last_name, B.dept_no, B.salary)
Values (e.employee_id, E.first_name, E.last_name, E.dept_no, E.salary)
Commit;
End;
 

/

Answer:
In merge statement u can not use thos columns in UPDATE SET statement which are specified in ON condition .....

here,u might be getting error like : Invalid Identifier Employee_id .... Rite?
so u just remove the line B.employee_id = E.employee_id from UPDATE SET
statement...