Oracle Database If...elsif ... Statement

CREATE OR REPLACE FUNCTION "Ufn_getids" (Opekind in VARCHAR2,--query type PARAMS in varchar2--query field) RETURN Clob is Str_return clob;--varchar2 (30000);

BEGIN      if      opekind = ' 1 '    then      & nbsp 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      & nbsp;       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     & nbsp;        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      & nbsp;       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 the 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 Database If...elsif ... Statement