在oracle中没有忽略大小写的方法,通常可以用upper(string)或者lower(string)来解决大小写问题,
比如
比如
select * from SYS_USER where UPPER(USERNO) = UPPER('JRunner')
或
select * from SYS_USER where LOWER(USERNO) = LOWER('JRunner')
或
select * from SYS_USER where LOWER(USERNO) = LOWER('JRunner')
转载于:https://blog.51cto.com/jrunner/357376