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
|