查询包含小写的所有数据：

selectoper_nofrominfo_operwhereregexp_like(oper_no,'[[:lower:]]');

selectoper_nofrominfo_operwhereregexp_like(oper_no,'[a-z]');



查询包含大写的所有数据：

selectoper_nofrominfo_operwhereregexp_like(oper_no,'[[:upper:]]');

selectoper_nofrominfo_operwhereregexp_like(oper_no,'[A-Z]');

保存一下。拿走不谢。