Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

sel_indx_cols.sql

Download Script

set linesize 132
set pagesize 80
break on table_name on index_name
col column_name format a30 trunc
select table_name, index_name, column_name
from dba_ind_columns
where   index_name like upper('%&Index_name%')
order by table_name, index_name, column_position
/