--查询姓名含非法字符的SQL语句
SELECT * FROM TABLE_NAME t
WHERE (REGEXP_LIKE(NAME, '[[:digit:]]+') OR
REGEXP_LIKE(NAME, '[[:punct:]]'))
AND NOT REGEXP_LIKE(NAME, '.*+\.^[\.]$')
AND NOT REGEXP_LIKE(NAME, '.*+\?.*+')
AND NOT REGEXP_LIKE(NAME, '.*+\..*+');
hdtiny 2018-02-06 08:49 原文
--查询姓名含非法字符的SQL语句
SELECT * FROM TABLE_NAME t
WHERE (REGEXP_LIKE(NAME, '[[:digit:]]+') OR
REGEXP_LIKE(NAME, '[[:punct:]]'))
AND NOT REGEXP_LIKE(NAME, '.*+\.^[\.]$')
AND NOT REGEXP_LIKE(NAME, '.*+\?.*+')
AND NOT REGEXP_LIKE(NAME, '.*+\..*+');