自定义函数里多if判断

create or replace function NJUTEC_GETNDKHSCORE(identity  in varchar2) return number is
Result number;
CNTS NUMBER:=0;
begin
  SELECT COUNT(1) INTO CNTS
  FROM person_ndkh_info t WHERE T.IDENTIFY=identity;
  if (CNTS>=5) then
     RESULT:=(CNTS*1)+5;
  elsif (CNTS>0) then
     RESULT:=CNTS*1;
  ELSE
     RESULT:=0;
  end if;
  return(Result);
end NJUTEC_GETNDKHSCORE;