oracle函数索引

1、使用函数索引使保存的数据区分大小写

--建表
create table t_user(
 usercode varchar2(10) primary key,
 username varchar2(60)
);
insert into t_user(usercode,username) values('UU','小强');
insert into t_user(usercode,username) values('uu','小李');
insert into t_user(usercode,username) values('Uu','小五');
insert into t_user(usercode,username) values('uU','小六');
commit;
--查询不区分大小写
select * from t_user where upper(usercode) = upper('变量值');
delete from t_user;
commit;
--建立函数索引
create unique index IN_T_USER_USERCODE on T_USER (UPPER(USERCODE));
insert into t_user(usercode,username) values('UU','小强');
insert into t_user(usercode,username) values('uu','小李');

--提示违反唯一性约束