Oracle 中判断字段是否有汉字

select length('姗姗') from dual;

select lengthb('姗姗') from dual;

select t.cont_code from ab001 t  wherelengthb(t.cont_code) > length(t.cont_code)

转载于:https://blog.51cto.com/agilitygod/1419917