如何让
select * from tablename where name = 'looxee'
和
select * from tablename where name = 'looXEe'
select * from tablename where name = 'lOOXEe'
查出来的结果一样?
ORACLE里是否有这样忽略大小写的函数?
select * from tablename where name = 'looxee'
和
select * from tablename where name = 'looXEe'
select * from tablename where name = 'lOOXEe'
查出来的结果一样?
ORACLE里是否有这样忽略大小写的函数?
upper() 转大写先规范再 select
http://gigabase.idi.ntnu.no/oradoc/server.901/a90125/functions2.htm#80856
查到。
oracle里面把字段放在条件‘’里的大小写都很敏感,放在外面就没有区别
例如:select * from table_name和select * from TABLE_NAME是没有区别的
但是select * from user_tables where table_name = 'table_name'和
但是select * from user_tables where table_name = 'TABLE_NAME'是完全不一样的
只能通过
lower() 转小写
upper() 转大写