rem ************************************************************* rem * Name : sh_index.SQL rem * rem * Date: July 15 2001 rem * Purpose: Show indexes on a table rem * rem * Downloaded from www.oradev.com rem ************************************************************* column index_name format A20 column column_name format A25 column column_position format 999 heading 'Pos' column uniq format a5 set verify off break on index_name skip 1 select C.index_name,substr(I.uniqueness,1,1) uniq, C.column_name, C.column_position from all_ind_columns C ,all_indexes I where C.table_owner = upper('&table_owner') and C.table_name = upper('&table_name') and C.index_owner = I.owner and C.index_name = I.index_name order by 2 desc,1,4 /