多列统计

 create or replace function njutec_evaluation(paramid in varchar2,paramtype in varchar2) return varchar2 is

  Result varchar2(4000);

  cnts integer:=0;

  tmpyear1 varchar2(20);

  tmpyear2 varchar2(20);

  tmpyear3 varchar2(20);

  tmpyear4 varchar2(20);

  tmpyear5 varchar2(20);

begin

  select t.year1 into tmpyear1 FROM hr_zgpssb t where t.id = paramid;

  select t.year2 into tmpyear2 FROM hr_zgpssb t where t.id = paramid;

  select t.year3 into tmpyear3 FROM hr_zgpssb t where t.id = paramid;

  select t.year4 into tmpyear4 FROM hr_zgpssb t where t.id = paramid;

  select t.year5 into tmpyear5 FROM hr_zgpssb t where t.id = paramid;

 if(tmpyear1 = paramtype) then

    cnts:=cnts+1;

  end if;

 if(tmpyear2 = paramtype) then

    cnts:=cnts+1;

  end if;

 if(tmpyear3 = paramtype) then

    cnts:=cnts+1;

  end if;

 if(tmpyear4 = paramtype) then

    cnts:=cnts+1;

  end if;

 if(tmpyear5 = paramtype) then

    cnts:=cnts+1;

  end if;

  Result:=cnts;

  return(Result);

end njutec_evaluation;