oracle查询条件不分大小写
如查询存储名称 job,可以显示出 JOB_REPORT_COUNT_INFO ,job_clearinvalid 这些,不分大小写 www.2cto.com
对应条件是=的,可以这样写upper(pro_name)=upper('job')
对于like 条件的话,upper(pro_name) like 'JOB%'
select pro_name,日期 ,sum(分钟) from (
select pro_name,batch_no,substr(id,1,8) 日期,round((max(log_date)-min(log_date))*24*60*60) 分钟
from sys_pro_monitor where upper(pro_name) like 'JOB%'
group by batch_no,pro_name,substr(id,1,8) order by batch_no desc) group by 日期,proracle账号o_name;
对于后台java处理时,如将参数传入,将参数转换为大写 www.2cto.com
select * from tablename where upper(ziduan) like '%" + ziduan.toUpperCase() + "%'"
sql += " and upper(t2.customer_name) like '%" + customerName.toUpperCase() + "%'";