隔了幾年再看, 有人提了另一個寫法, 可參考:
--
SET SERVEROUTPUT ON;
DECLARE
b_isvalid BOOLEAN;
BEGIN
b_isvalid :=
REGEXP_LIKE ('anyaddress@xyz123.com',
'^[A-Za-z0-9._%+-]+@[A-Za-z0-9.-]+\.[A-Za-z]{2,4}$');
IF b_isvalid
THEN
DBMS_OUTPUT.put_line ('It is a valid email address.');
ELSE
DBMS_OUTPUT.put_line ('It is Not a valid email address.');
END IF;
END;
/
Ref:
1.Validate Email Using PL/SQL Program
How to Validate Email Address Using PL/SQL? - foxinfotech.in
沒有留言:
張貼留言
注意:只有此網誌的成員可以留言。