Oracle在PL/SQL中嵌入SQL语句_oracle

v_ename emp.ename%type;
v_sal   emp.sal%type;
select ename,sal into v_ename,v_sal from emp where empno=&no;

v_deptno emp.deptno%type:=&no;
insert into employee select * from emp where deptno=v_deptno;

v_ename emp.ename%type:='&name';
update emp set (sal,comm) = (select sal,comm from emp where ename=v_ename) where job = (select job from emp where ename=v_ename)

v_ename emp.ename%type:='&name';
  delete from emp where deptno=(select deptno from emp where ename=v_ename);