oracle编写函数案例--江苏教育智慧平台

create or replace function ims_ing2(exam_no_in  in varchar2,student_no_in in varchar2,busi_process_no_in in varchar2)return varchar2
 is
  v_return varchar2(120) default 1;
  begin 
declare CURSOR cura is
select is_right
    from train_exam_student_item where exam_no=exam_no_in and student_no=student_no_in and BUSI_PROCESS_NO=busi_process_no_in;
  BEGIN
  for idx in cura loop
    exit when cura%notfound; 
  if idx.is_right = '0'
  --如果有答案中有一个是0,就给它赋值为0
  then v_return:='0';
  end if;
  end loop;
   RETURN v_return;
   end;
 END;