例如:
select c_bbh TABLE t1 结果如下:
想把C_BBH分成V和5则使用:
select
replace(translate(data,'1234567890','0000000000'),'0','') as bbzm,
to_number(replace(translate(lower(data),'abcdefghijklmnopqrstuvwxyz',rpad('z',26,'z')),'z','')) as bbsz
from
(
select c_bbh TABLE t1
)
得到结果为:
问题解决。