create or replace function field_increase return number
is
result number;
begin
select max(t.c_sscore) into result from class t;
if (result is NULL) then
result := 0;
else
result := result + 1;
end if;
return result;
end field_increase;
转载于:https://blog.51cto.com/xuehongrui/1324678