在自定义的函数上建立function-based索引;
SQL> create index idx_001 on a(func_ib(comoon));
create index idx_001 on a(func_ib(comoon))
*
ERROR at line 1:
ORA-30553: The function is not deterministic
--------------增加关键字deterministic
create or replace function func_ib (v_comoon varchar2)
return varchar2 deterministic is
v_var1 varchar2(8);
begin
v_var1:=upper(v_comoon);
return v_var1;
end;
SQL> create index idx_001 on a(func_ib(comoon));
Index created.