Re: How to find non printable characters in a column using regexp
- From: "Vlad Sadilovskiy" <vlovsky@xxxxxxxxx>
- To: psinger1@xxxxxxxxxxxxx
- Date: Thu, 19 Apr 2007 22:19:31 -0400
This migh also help:
select value
from (select 'A' value from dual
union select 'AA' value from dual
union select chr(1)||'B' value from dual
union select 'AAA' value from dual)
where
length(translate(value,'A'||chr(01)||chr(02)||chr(03)||chr(04)||chr(05)||chr(06)||chr(07)||chr(08)||
chr(11)||chr(12)||chr(14)||chr(15)||chr(16)||chr(17)||chr(18)||chr(19)||chr(20)||
chr(21)||chr(22)||chr(23)||chr(24)||chr(25)||chr(26)||chr(27)||chr(28)||chr(29)||chr(30)||chr(31),'A'))
= length(value);
- Vlad
Other related posts:
