CREATE OR REPLACE FUNCTION checkMsisdn (msisdn IN VARCHAR2)
RETURN INT
IS
v_regstr Varchar2(2000):='^(150|151|152|158|159|13[4-9]{1})[0-9]{8}$';
Begin
/*
wzh 20091124 验证 手机号码是否是移动号码
*/
IF REGEXP_LIKE (msisdn, v_regstr)
THEN
RETURN 1;
Else
RETURN 0;
END IF;
EXCEPTION
WHEN OTHERS
Then
RETURN 0;
END checkMsisdn;
RETURN INT
IS
v_regstr Varchar2(2000):='^(150|151|152|158|159|13[4-9]{1})[0-9]{8}$';
Begin
/*
wzh 20091124 验证 手机号码是否是移动号码
*/
IF REGEXP_LIKE (msisdn, v_regstr)
THEN
RETURN 1;
Else
RETURN 0;
END IF;
EXCEPTION
WHEN OTHERS
Then
RETURN 0;
END checkMsisdn;