with t as(
select '大家好' col from dual
union all select '大家好！' from dual
union all select '大家好AXZ' from dual
union all select '大家好,aX@' from dual
union all select '大家好,1，aX@' from dual
union all select '大家好abd' from dual
union all select '大家好123' from dual
union all select '大家好，。' from dual
union all select '大家好，12' from dual
union all select '大家好abc，。' from dual
union all select '大家好abc123' from dual
)
select col from t
WHERE not regexp_like(col,'([[:punct:]]+|[a-zA-Z]+|[0-9]+)','i');
select '大家好' col from dual
union all select '大家好！' from dual
union all select '大家好AXZ' from dual
union all select '大家好,aX@' from dual
union all select '大家好,1，aX@' from dual
union all select '大家好abd' from dual
union all select '大家好123' from dual
union all select '大家好，。' from dual
union all select '大家好，12' from dual
union all select '大家好abc，。' from dual
union all select '大家好abc123' from dual
)
select col from t
WHERE not regexp_like(col,'([[:punct:]]+|[a-zA-Z]+|[0-9]+)','i');
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/7580948/viewspace-1824499/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
使用sample优化SQL
下一篇：
BULK COLLECT
请登录后发表评论
登录
全部评论
