查询包含小写的所有数据:
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]');
查询包含大写的所有数据:
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]');
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]');
查询包含大写的所有数据:
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]');
保存一下。 拿走不谢。