set serveroutoput on
declare
cursor cemp is select empname empjal from emp
pempno emp.empno% type;
pempname emp.empname%type ;
begin
--打开光标
open cmep ;
close cemp;
end;
/
declare
cursor cemp is select empname empjal from emp
pempno emp.empno% type;
pempname emp.empname%type ;
begin
--打开光标
open cmep ;
close cemp;
end;
/
2017-12-23
已采纳回答 / 手转乾坤
declare cursor cemp is select empno ,sal from emp order by sal; --定义参数 pempno emp.empno%type; psal emp.sal%type; countEmp number :=0; salTotal number; begin --得到工资总额的初始值 select sum(sal) into salTotal from emp; --打开光标 open c...
2017-10-30