[ORACLE] 사용자 Function 생성

 

-->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
-- 분류코드와 코드를 이용해 코드명을 가져온다.
-->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>

CREATE OR REPLACE
FUNCTION GET_CODE_NAME (
      p_cl_code IN VARCHAR2                --입력되는 인자값1
    , p_code     IN VARCHAR2                --입력되는 인자값2
)RETURN VARCHAR2 IS
    v_return VARCHAR2(50);

BEGIN
    SELECT CODE_NM1 
         INTO v_return
        FROM CMM_CODE_INFO
      WHERE CL_CODE = p_cl_code
           AND CODE = p_code;
    RETURN v_return;
   
    EXCEPTION
        WHEN NO_DATA_FOUND THEN
            RETURN '';
        WHEN OTHERS THEN
            RETURN '';
END GET_CODE_NAME;