开发者

oracle sql - query to find special chars

开发者 https://www.devze.com 2023-04-05 20:02 出处:网络
Is there any SQL SELECT query that can be done in oracle to detect ascii characters such as LF, CR in fields? Basically any characters people have known to cause tro开发者_开发技巧uble in a oracle db

Is there any SQL SELECT query that can be done in oracle to detect ascii characters such as LF, CR in fields? Basically any characters people have known to cause tro开发者_开发技巧uble in a oracle db environment in terms of breaking jobs/procedures.etc

I doubt this would work: - happy to use regex if possible

select * from table
where column like '%chr(13)%'


select * from table
where regexp_like(column, '(' || chr(13) || '|' || chr(10) || ')')

The regex used here is a form of (a|b|c) which matches the string if it contains a OR b OR c

0

精彩评论

暂无评论...
验证码 换一张
取 消