What Type of Index

set wrap off linesize 132 pages 80;

column pos format 990;
column col format a10;
column index format a25;
column table format a25;
column type format a20;
column tablespace format a25;

select t.table_name "Table",decode(t.index_type,'NORMAL','BTree','BITMAP','Bitmap' ,'FUNCTION-BASED NORMAL','Function-Based BTree',t.index_type) "Type"
,t.index_name "Index",c.column_name "Col", c.column_position "Pos"
,t.tablespace_name "Tablespace"
from user_indexes t, user_ind_columns c
where t.table_name = c.table_name
and t.index_name = c.index_name
order by t.index_type desc, t.table_name, t.index_name, c.column_position;