when 8 then rank:=‘b‘;
when 7 then rank:=‘c‘;
when 6 then rank:=‘d‘;
when 5 then rank:=‘e‘;
end case;
dbms_output.put_line(rank);
end;
Oracle数据库建表并用SQL编程分等级
标签：
Oracle数据库建表并用SQL编程分等级
when 8 then rank:=‘b‘;
when 7 then rank:=‘c‘;
when 6 then rank:=‘d‘;
when 5 then rank:=‘e‘;
end case;
dbms_output.put_line(rank);
end;