oracle数据库存储过程

【例7】完善下面的查询，实如下功能：创建名为“PROC_changedept”的存储过程，实现员工部门的调动，并以不同参数调用。（有三个空）

CREATE OR REPLACE PROCEDURE proc_changedept (
p_empno emp.empno%type,
p_new_dept_name dept.dname%type)
AS
v_old_deptno dept.deptno%type;
v_old_dept_name dept.dname%type;
v_new_deptno dept.deptno%type;
BEGIN
SELECT deptno INTO v_old_deptno FROM emp WHERE empno=p_empno;
SELECT dname INTO v_old_dept_name FROM dept WHERE deptno=v_old_deptno;
IF —————————————————————— THEN
RAISE_APPLICATION_ERROR(-20001,'the new department name is as same as before!');
END IF;
SELECT ———————————————— FROM dept
WHERE dname=p_new_dept_name;
UPDATE emp SET ——————————————————————
WHERE empno=p_empno;
COMMIT;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RAISE_APPLICATION_ERROR(-20002,'The department name does not exists!');
END proc_changedept;
/

select fileds from table
update table set fileds = value