一个表TEST中的字段prod_name 中有下列值:'HRB335 螺纹钢 ф36*9m'如何取出产品名称中的'螺纹钢'三个汉字
1.
select trim(translate('HRB335 螺纹钢 ф36*9m',
'0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ*фm',
' '))
from dual
2.
select regexp_replace(var,'[0-9,a-z,A-Z, ]+' ) from youtable过滤
3.
select distinct regexp_replace('HRB335 螺纹钢 ф36*9m',
'[[:digit:]]|[[unct:]]|[[:upper:]]|[[:lower:]]|[[unct:]]+',
'')
from dual;