select data,translate(lower(data),
    '1234567890qwertyuiopasdfghjklzxcvbnm',
    rpad('a',36,'a') )  translated
  , rpad('a',length(data),'a') fixed
from V
    data        translated           fixed
ADAMS$,1100.00    aaaaa$,aaaa.aa    aaaaaaaaaaaaaa
CLARK    aaaaa    aaaaa
FORD$,3000.00    aaaa$,aaaa.aa    aaaaaaaaaaaaa
JONES$,2975.00    aaaaa$,aaaa.aa    aaaaaaaaaaaaaa
KING    aaaa    aaaa
MILLER    aaaaaa    aaaaaa
SCOTT$,3000.00    aaaaa$,aaaa.aa    aaaaaaaaaaaaaa
SMITH$,800 .00    aaaaa$,aaa .aa    aaaaaaaaaaaaaa
ALLEN30      aaaaaaa      aaaaaaaaa
WARD30      aaaaaa      aaaaaaaa
MARTIN30      aaaaaaaa      aaaaaaaaaa
BLAKE30      aaaaaaa      aaaaaaaaa
TURNER30      aaaaaaaa      aaaaaaaaaa
JAMES30      aaaaaaa      aaaaaaaaa

我用下面语句查询只得到了3个结果 部门号为30的结果没显示出来  上面的查询显示字符串的长度怎么会不一样
select data
from V
where translate(lower(data),
    '0123456789abcdefghijklmnopqrstuvwxyz',
    rpad('a',36,'a'))=rpad('a',length(data),'a')

CLARK
KING
MILLER

with t1 as
(
     select 'asdf234' c1 from dual
     union all
     select 'asdf334#@sdf' from dual
     union all
     select 'a23423ds' from dual
     union all
     select 'a<>?sdf' from dual
)

select c1 
from t1
where REGEXP_REPLACE(c1,'[0-9|a-z|A-Z]','') is null;


      c1
-----------------------------
1    asdf234
2    a23423ds