Oracle query conditions are case-insensitive

Oracle query conditions are case-insensitive. For example, if the storage name job is queried, JOB_REPORT_COUNT_INFO and job_clearinvalid can be displayed. The conditions for www.2cto.com are =. You can write upper (pro_name) in this way) = upper ('job') for the like condition, upper (pro_name) like 'job % 'select pro_name, date, sum (minute) from (select pro_name, batch_no, substr (id, 1, 8) date, round (max (log_date)-min (log_date) * 24*60*60) minutes from sys_pro_monitor where upper (pro_name) like 'job % 'group by batch_no, pro_name, substr (id,) order by batch_no desc) group by date, pro_name; For background java processing, such as passing in parameters, convert the parameter to uppercase: www.2cto.com select * from tablename where upper (ziduan) like '% "+ ziduan. toUpperCase () + "% '" SQL + = "and upper (t2.customer _ name) like' %" + customerName. toUpperCase () + "% '";