我的代码有什么问题
sql> declare 2 mark number :=50; 3 begin 4 mark :=& mark; 5 if (mark between 85 and 100) 6 then 7 dbms_output.put_line('mark is A '); 8 else if (mark between 50 and 65) then 9 dbms_output.put_line('mark is D '); 10 else if (mark between 66 and 75) then 11 dbms_output.put_line('mark is C '); 12 else if (mark between 76 and 84) then 13 dbms_output.put_line('mark is B'); 14 else 15 dbms_output.put_line('mark is F'); 16 end if; 17 end; 18 / Enter value for mark: 65 old 4: mark :=& mark; new 4: mark :=65; end; *
ERROR at line 17:
ORA-06550: line 17,column 4:
PLS-00103: Encountered the symbol “;” when expecting one of the following:
if
问题是else和if是两个运算符.由于你打开一个新的’if’,你需要一个相应的’end if’.
从而：
declare
mark number :=50;
begin
mark :=& mark;
if (mark between 85 and 100) then
dbms_output.put_line('mark is A ');
else
if (mark between 50 and 65) then
dbms_output.put_line('mark is D ');
else
if (mark between 66 and 75) then
dbms_output.put_line('mark is C ');
else
if (mark between 76 and 84) then
dbms_output.put_line('mark is B');
else
dbms_output.put_line('mark is F');
end if;
end if;
end if;
end if;
end;
/
或者你可以使用elsif：
declare
mark number :=50;
begin
mark :=& mark;
if (mark between 85 and 100)
then
dbms_output.put_line('mark is A ');
elsif (mark between 50 and 65) then
dbms_output.put_line('mark is D ');
elsif (mark between 66 and 75) then
dbms_output.put_line('mark is C ');
elsif (mark between 76 and 84) then
dbms_output.put_line('mark is B');
else
dbms_output.put_line('mark is F');
end if;
end;
/
