满意答案
brainxi
推荐于 2017.11.25
采纳率:55% 等级:12
已帮助:10326人
||要在V_total_salary:=v_total_salary + rec_emp.sal 后加5261分号,下面的已经改好了。4102试试吧。
DECLARE
v_Total_Salary NUMBER;
BEGIN
FOR Rec_Dept IN (SELECT Deptno,
Dname
FROM Dept
ORDER BY Deptno) LOOP
Dbms_Output. Put_Line('department:' ||1653 Rec_Dept.Deptno || '-' || Rec_Dept.Dname);
v_Total_Salary := 0;
FOR Rec_Emp IN (SELECT Ename,
Sal
FROM Emp
WHERE Deptno = Rec_Dept.Deptno
ORDER BY Ename) LOOP
Dbms_Output.Put_Line('name:' || Rec_Emp.Ename || 'salary:' || Rec_Emp.Sal);
v_Total_Salary := v_Total_Salary + Rec_Emp.Sal;
END LOOP;
Dbms_Output.Put_Line('total salary for dept:' || v_Total_Salary);
END LOOP;
END;
00分享举报