DBA_INDEXES and DBA_IND_COLUMNS

set wrap off linesize 200 pages 5000 column tab format a25 column typ format a5 column ind format a25 column col format a20 column pos format 990 column tbs format a25 col unq format a3 col deg format a8 select t.table_name “Tab” ,decode(t.index_type,’NORMAL’,’BTree’,’BITMAP’,’Bitmap’,’FUNCTION-BASED NORMAL’,’Function-Based BTree’,t.index_type) “Typ” ,t.status ,t.index_name “Ind” ,c.column_name “Col” ,c.column_position “Pos” ,decode(t.uniqueness,’UNIQUE’,’UNQ’,NULL) “unq” …