日期:2014-05-17 浏览次数:20989 次
select count(1) from dual where regexp_like('0000800000','^[[:digit:]]*([[:digit:]*8[:digit:]]*){4}([[:digit:]*8[:digit:]]*){4}$')
select count(1) from dual where regexp_like(substr('1234567890',-8,4),'(\d.*?){1}') and regexp_like(substr('1234567890',-4),'(\d.*?){1}')