oracle安装错误10301,用oracle SQL*Plus运行程序，出错，显示:出现符号"END"在需要下列之一时:符号";"被替换为"END"后继续。...

满意答案

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分享举报