- create or replace function func_level(score number)
- return varchar
- as
- begin
- declare
- lname varchar(10);
- begin
- select levelname into lname from userlevels where levelscore>=score and rownum=1 ;
- return lname;
- end;
- end;
- --该片段来自于http://www.codesnippet.cn/detail/1706201614738.html
来源: http://www.codesnippet.cn/detail/1706201614738.html