Oracle中PL/SQL的CASE语句
declareresult varchar2(10);
begin
case '&grade'
when 'A' then result := '优秀';
when 'B' then result := '良好';
when 'C' then result := '合格';
when 'D' then result := '不及格';
else result := '没有此成绩';
end case;
dbms_output.put_line(result);
end;
页:
[1]