Creating Function based Index

scott>create index fun_ind on emp(lower(ename));
scott>select a.table_name,a.index_name,a.index_type,b.column_name from user_indexes a,user_ind_columns b where a.table_name=b.table_name;
scott>conn / as sysdba