INDEX 정보 조회

/********************************************************************/
/*INPUT : table명 (대소문자 구분 없음 - 2자 이상) */
/********************************************************************/

--table에 생성된 index 정보 조회
select c.comments 엔티티명,
a.table_name 테이블명,
a.index_name 인덱스명,
a.column_name 컬럼영문명,
b.comments 컬럼한글명,
a.column_position IDX컬럼순서,
a.descend
from all_ind_columns a, all_col_comments b, all_tab_comments c
where a.table_name like UPPER('&TABLE_NAME') ||'%'
AND length(a.table_name) = 8
and b.table_name = a.table_name
and b.column_name = a.column_name
and c.table_name = a.table_name
order by a.table_name, a.index_name, a.column_position;