Function

Function创建调用示例
CREATE OR REPLACE FUNCTION FN_CHECKNUMBER(PHONENUMBER IN VARCHAR2)
RETURN VARCHAR2 IS
VALIDFLAG VARCHAR2(1);
LEN INT := 0;
STR VARCHAR2(2);
BEGIN
LEN := LENGTH(PHONENUMBER);
STR := SUBSTR(PHONENUMBER, 0, 2);
IF PHONENUMBER IS NULL OR LEN > 11 OR LEN < 11 OR STR = '11' OR
STR = '12' OR STR = '16' OR STR = '17' OR STR = '19' OR
PHONENUMBER = '13800138000' THEN
VALIDFLAG := 'N';
ELSE
VALIDFLAG := 'Y';
END IF;
RETURN VALIDFLAG;
END FN_CHECKNUMBER;
调用的时候直接可以用

select FN_CHECKNUMBER('传参') from dual;