column INDEX_OWNER format a20
column TABLE_NAME format a20
column column_NAME format a20
column INDEX_NAME format a20

BREAK ON INDEX_OWNER ON TABLE_NAME ON INDEX_NAME NODUP

select DIC.INDEX_OWNER,DIC.table_name,DIC.index_name,DIC.COLUMN_POSITION,DIC.COLUMN_NAME,DTC.histogram
from DBA_IND_COLUMNS DIC, DBA_tab_COLUMNS DTC
where DIC.INDEX_OWNER like upper('&1')
and DIC.table_name like upper('&2')
and DIC.INDEX_OWNER = DTC.OWNER
and DIC.table_name = DTC.table_name
and DIC.COLUMN_NAME = DTC.COLUMN_NAME
order by DIC.INDEX_OWNER,DIC.table_name,DIC.index_name,DIC.COLUMN_POSITION;

CLEAR BREAKS