Oracle Development Common functions

Max Maximum number auto plus 1

Create or Replace function Fun_getmaxlot (       vend in varchar2,       domain in VARCHAR2,       tag in varchar2) RETURN Varch AR2 as  maxval     VARCHAR2 (40); NEWIQC     VARCHAR2 (40); TT         VARCHAR2 (12); Begin     Begin      Select MAX (xsld_lot) into Maxval from     Xsld_det     where xsld_lot like     Upper (tag) | | to_ char (sysdate, ' yyMMdd ') | | Upper (vend) | | ' % ' and      UPPER (xsld_domain) = UPPER (domain);      if (Maxval is null) then         return upper (tag) | | To_char (sysdate, ' yyMMdd ') | | Upper (vend) | | ' 001 ';      End If;      NEWIQC: = replace (maxval, Upper (tag) | | To_char (sysdate, ' yyMMdd ') | | Upper (Vend), ");        TT: = (newiqc*1 + 1) | | ";        For M in LENGTH (TT): (2) Loop            TT: =  ' 0 ' | | TT;        End Loop;        return upper (tag) | | To_char (sysdate, ' yyMMdd ') | | Upper (vend) | | TT;     EXCEPTION when No_data_found and then         RETURN ';     END; END;

Oracle Development Common functions