CREATE OR REPLACE FUNCTION PRMUSER.FN_DLR_INDX_FULL_CD
(
I_DLR_CD TBL_DLR_MSTR_INF.DLR_CD%TYPE
)
RETURN VARCHAR2
IS
O_RESULT TBL_DLR_MSTR_INF.DLR_INDX%TYPE;BEGIN
O_RESULT := ''; SELECT CASE WHEN DLR_DV_CD = '40' AND DLR_INDX IS NOT NULL THEN HIRA_DLR_CD || DLR_INDX
ELSE ''
END
INTO O_RESULT
FROM TBL_DLR_MSTR_INF
WHERE DLR_CD = I_DLR_CD
; RETURN O_RESULT;EXCEPTION
WHEN OTHERS THEN
RETURN NULL;
END FN_DLR_INDX_FULL_CD;
(
I_DLR_CD TBL_DLR_MSTR_INF.DLR_CD%TYPE
)
RETURN VARCHAR2
IS
O_RESULT TBL_DLR_MSTR_INF.DLR_INDX%TYPE;BEGIN
O_RESULT := ''; SELECT CASE WHEN DLR_DV_CD = '40' AND DLR_INDX IS NOT NULL THEN HIRA_DLR_CD || DLR_INDX
ELSE ''
END
INTO O_RESULT
FROM TBL_DLR_MSTR_INF
WHERE DLR_CD = I_DLR_CD
; RETURN O_RESULT;EXCEPTION
WHEN OTHERS THEN
RETURN NULL;
END FN_DLR_INDX_FULL_CD;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货