首页 > 代码库 > oracle 数据库 if...elsif...语句
oracle 数据库 if...elsif...语句
CREATE OR REPLACE FUNCTION "UFN_GETIDS" ( OPEKIND IN VARCHAR2,-- 查询类型 PARAMS IN VARCHAR2-- 查询字段 ) RETURN clob IS str_return clob;--varchar2(30000);
BEGIN if OPEKIND = ‘1‘ then declare Cursor cusor1 is SELECT ………………; begin for x in cusor1 loop str_return := str_return || x.OUID || ‘,‘; end loop; end;
elsif OPEKIND = ‘2‘ then declare Cursor cusor1 is SELECT ……………………; begin for x in cusor1 loop str_return := str_return || x.OILDOMID || ‘,‘; end loop; str_return:= substr(str_return,0,length(str_return)-1); end;
elsif OPEKIND = ‘3‘ then declare Cursor cusor1 is SELECT ………………; begin for x in cusor1 loop str_return := str_return || x.OILDOMID || ‘,‘; end loop; str_return:= substr(str_return,0,length(str_return)-1); end;
elsif OPEKIND = ‘4‘ then declare Cursor cusor1 is SELECT ……………………; begin for x in cusor1 loop str_return := str_return || x.OILDOMID || ‘,‘; end loop; str_return:= substr(str_return,0,length(str_return)-1); end;
elsif OPEKIND = ‘5‘ then declare Cursor cusor1 is SELECT …………………………; begin for x in cusor1 loop str_return := str_return || x.OILDOMID || ‘,‘; end loop; str_return:= substr(str_return,0,length(str_return)-1); end; end if;
RETURN str_return; END;
oracle 数据库 if...elsif...语句