set serveroutoput on
declare
cursor cemp is select empname empjal from emp
pempno emp.empno% type;
pempname emp.empname%type ;
begin
--打開光標
open cmep ;
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...
