Oracle自定义函数示例

create or replace function getStu_name(s_stu_id varchar2) return varchar2 is  --声明变量  Result     varchar2(1000);  stu_cursor my_cursor;  sex        int;  stu_name   varchar2(1000);  --定义游标  type my_cursor is ref cursor;begin  --打开游标  open stu_cursor for    select stu_name, sex from tb_gyf_students where stu_id = s_stu_id;  loop    --循环    fetch stu_cursor      into stu_name, sex; --读取游标存入变量    exit when stu_cursor%notfound; --循环结束条件    --if判断    if sex = 1 then         Result := stu_name || ',' || Result; --业务逻辑    end if; --结束判断  end loop; --结束循环  return(Result); --返回业务逻辑处理结果end getStu_name; --结束函数--  select stu_name,getstu_name(stu_id) from TB_GYF_STUDENTS  调用示例