oracle 正则表达式匹配
AV-QWERQWER
[[任何字母]]{2位}[[任何白字符]]{1位}[[任何字母]]{8位}
select count(*) from tableName where regexp_like(colName, '[[:alpha:]]{2}[[:space:]]{1}[[:alpha:]]{8}')
123456789
[[任何数字]]{9位}
select count(*) as num from tableName where regexp_like(colName, '[[:digit:]]{9}')