查询包含小写的所有数据
1
2
select oper_no from info_oper where regexp_like(oper_no,'[[:lower:]]');
select oper_no from info_oper where regexp_like(oper_no,'[a-z]');
查询包含大写的所有数据
1
2
select oper_no from info_oper where regexp_like(oper_no,'[[:upper:]]');
select oper_no from info_oper where regexp_like(oper_no,'[A-Z]');