WHAT IS THE PROBLEM WITH THIS QUERY . WHERE I AM MAKING MISTAKE.
ANY BODY CAN HELP ME.


MERGE into copy_emp AS c
USING emp e
ON (c.empno = e.empno)
WHEN MATCHED THEN
UPDATE SET
c.empno = e.empno,
c.ename = e.ename,
c.job = e.job,
c.mgr = e.mgr,
c.hiredate = e.hiredate,
c.sal = e.sal,
c.comm = e.comm,
c.deptno = e.deptno
WHEN NOT MATCHED THEN
insert values (e.empno,e.name,e.job,e.mgr,e.hiredate,e.sal,e.comm,e.deptno);

WHEN I AM GOING TO RUN THIS CODE THE FOLLOWING ERROR ARAISE.

SQL> /
MERGE into copy_emp AS c
*
ERROR at line 1:
ORA-02012: missing USING keyword

THANKS
SOHAIL