/* ************************************************ */
/*                                                  */
/* format the report:                               */
/*        SRL CASE ATTRIBUTE                        */
/*                                                  */
/* name:    @c:\oracle\sql\dbaindec.sql             */
/* date:    12-MAY-95                               */
/* creator: Rick Kupcunas (Oracle)                  */
/*                                                  */
/* ************************************************ */

set feedback  off
set WRAP      off
set pagesize  60
set linesize  75 
set space     5
set newpage   0
set trimout   on
set verify    on
set underline =
set echo      off
set termout   off

whenever sqlerror exit failure
spool dbaindcol.lst

ttitle left 'PAGE:' sql.pno format 999 - 
center 'DBAINDEC - Table and Index Extents' -
right CWS_DATE skip 2

 column index_name			format A20 heading 'INDEX'
 column table_name			format A20 heading 'TABLE'
 column column_name			format A20 heading 'COLUMN'
 break   on  index_name skip 1

select index_name,table_name,COLUMN_NAME
from sys.dba_ind_columns
where index_owner = '&&INDEX_OWNER'
order by table_name,index_name,column_position;

undefine &INDEX_OWNER;

spool off
exit
