摘要: 1、正则表达式写法: 1 CREATE OR REPLACE FUNCTION fn_checkidcard (p_idcard IN VARCHAR2) RETURN INT 2 IS 3 v_regstr VARCHAR2 (2000); 4 v_sum NUMBER; 5 v_mod NUMBER; 6 v_checkcode CHAR (11) := '10X98765432'; 7 v_checkbit CHAR (1); 8 v_areacode VARCHAR... 阅读全文
posted @ 2012-01-05 10:37 马侃 阅读(21512) 评论(3) 推荐(6)