Oracle Function

 

CREATE OR REPLACE FUNCTION FUN_NO_XJT(P_HEAD VARCHAR2,
                                      P_DATE DATE,
                                      P_NUM  VARCHAR2) RETURN VARCHAR2 IS
  L_GET_NO VARCHAR2(50);

BEGIN

  SELECT P_HEAD || TO_CHAR(P_DATE, 'YYMM') ||
         LPAD(SEQ_TEST_XJT.NEXTVAL, 5, '0')
    INTO L_GET_NO
    FROM DUAL;

  RETURN L_GET_NO;
EXCEPTION
  WHEN OTHERS THEN
    RETURN '00000000';
END FUN_NO_XJT;