查找字符串中的汉字
SELECT REPLACE (wmsys.wm_concat (a.sub2), ',') AS cstr
FROM (SELECT ROWNUM AS rn, b.s1 AS s1, SUBSTR (SUBSTR (b.s1, ROWNUM), 0, 1) AS sub2,
ASCII (SUBSTR (SUBSTR (b.s1, ROWNUM), 0, 1)) AS asub2
FROM DUAL a,
(SELECT 'abc测试1' AS s1
FROM DUAL) b
CONNECT BY ROWNUM <= LENGTH (b.s1)) a
WHERE a.asub2 > 128;
判断是否有汉字--lengthb函数
select * from user a where
SUBSTR (a.code, 1, 2)='02'
and length(SERVICE_ID)<>lengthb(SERVICE_ID)