不支持这种写法,try:
declare
grade char := 'a';
appraisal varchar2(20);
begin
select decode(grade,'a','exce','b','good','no') into appraisal from dual;
dbms_output.put_line(appraisal);
end;
declare
grade char := 'a';
appraisal varchar2(20);
begin
select decode(grade,'a','exce','b','good','no') into appraisal from dual;
dbms_output.put_line(appraisal);
end;
grade char := 'a';
appraisal varchar2(20);
begin
appraisal := case
when grade='a' then 'exce';
when grade='b' then 'good';
else 'no';
end case
end;
dbms_output.put_line(appraisal);
end;
grade char := 'a';
appraisal varchar2(20);
begin
appraisal := case
when grade='a' then 'exce';
when grade='b' then 'good';
else 'no';
end case ;
end;
dbms_output.put_line(appraisal);
end;用这个吧---