set echo off
--
--  Name: show_dba_indexes.sql  
--
--  Parms: [optional] 
--     #1: owner
--     #2: table_name
--
--  Description: Indexes - Display all indexes and columns for a specified owner and table 
--
--  Compatability: 7.3 and above
--
--  Usage: @show_dba_indexes owner table_name     
--         @show_dba_indexes sysadm tablea
--
set verify off
--
define lsize=133
set linesize &&lsize
--
column column_position format 99
column column_name format A30
column index_name format A30 
break on index_name 
select /*+RULE */ b.index_name, decode(column_position,1,uniqueness,' ') uniqueness, a.column_name, a.column_position 
from dba_ind_columns a, dba_indexes b
where b.table_name = upper('&&2')
and b.table_owner = upper('&&1')
and a.index_owner = b.owner
and a.index_name = b.index_name
and a.table_owner = b.table_owner
and a.table_name = b.table_name
order by a.index_name, a.column_position
;
--
set verify on