List of index in a oracle table

SQL> select index_name, substr(column_name,1,20) column_name,
2 column_position
3 from dba_ind_columns
4 where upper(table_name) like upper('%&T%')
5 order by 1,3
6 ;

INDEX_NAME COLUMN_NAME COLUMN_POSITION
------------------------------ -------------------- ---------------
KNM_ANREQ_DTL_N1 REQ_LINE_ID 1
KNM_ANREQ_DTL_N1 REQ_NO 2
KNM_ANREQ_DTL_U1 REQ_LINE_ID 1
KNM_ANREQ_HDR_N1 DEPT_VALUE 1
KNM_ANREQ_HDR_N1 REQ_NO 2
KNM_ANREQ_HDR_U1 REQ_NO 1
KNM_CHQ_DTL_N1 HDR_ID 1
KNM_CHQ_DTL_N1 CHK_HANDED_OVER_DATE 2
KNM_CHQ_DTL_N1 PAYMENT_ID 3
KNM_EMD_INFO_N1 EMD_ID 1
KNM_EMD_INFO_N1 PO_HEADER_ID 2
KNM_EMD_INFO_N1 ORGANIZATION_ID 3
KNM_EMD_INFO_N1 RECEIPT_NUM 4
KNM_EMD_INFO_U1 EMD_ID 1
KNM_INSP_N1 HDR_ID 1
KNM_INSP_N1 IRR_NO 2
KNM_INSP_N1 INVENTORY_ITEM_ID 3
KNM_INSP_N1 ORGANIZATION_ID 4
KNM_INSP_N2 ORGANIZATION_ID 1
KNM_INSP_N2 INVENTORY_ITEM_ID 2

INDEX_NAME COLUMN_NAME COLUMN_POSITION
------------------------------ -------------------- ---------------
KNM_INSP_U1 HDR_ID 1
KNM_INV_REF_DTL_N1 INVREF_ID 1
KNM_INV_REF_DTL_N1 INVREF_LINE_ID 2
KNM_INV_REF_DTL_N1 DED_NAME 3
KNM_INV_REF_DTL_N1 SUBMIT_FLAG 4
KNM_INV_REF_DTL_U1 INVREF_ID 1
KNM_INV_REF_DTL_U1 INVREF_LINE_ID 2
KNM_INV_REF_HDR_N1 INVREF_ID 1
KNM_INV_REF_HDR_N1 PO_HEADER_ID 2
KNM_INV_REF_HDR_N1 VENDOR_ID 3
KNM_INV_REF_HDR_N1 SUBMIT_FLAG 4
KNM_INV_REF_HDR_U1 INVREF_ID 1
KNM_ISSUE_U1 TRANSACTION_NO 1
KNM_ISSUE_U1 ISSUE_ID 2
KNM_ITEMWISE_ONHAND_THR_ID_PK THR_ID 1
KNM_MAT_ASSG_LINE_N1 TRANSACTION_NO 1
KNM_MAT_ASSG_LINE_N1 SL_NO 2
KNM_MAT_ASSG_N1 TRANSACTION_NO 1
KNM_MAT_ASSG_N1 REQUEST_NUM 2
KNM_MAT_CONS_U1 LINE_ID 1
KNM_MAT_ISSUE_DTL_BATCH_N1 MAT_REQUEST_NUM 1

INDEX_NAME COLUMN_NAME COLUMN_POSITION
------------------------------ -------------------- ---------------
KNM_MAT_ISSUE_DTL_BATCH_N1 ISSUE_ID 2
KNM_MAT_ISSUE_DTL_BATCH_N1 INVENTORY_ITEM_ID 3
KNM_MAT_ISSUE_DTL_BATCH_N1 ORGANIZATION_ID 4
KNM_MAT_ISSUE_DTL_BATCH_N1 LOT_NO 5
KNM_MAT_REQ_LINE_N1 HEADER_ID 1
KNM_MAT_REQ_LINE_N1 ITEM_ID 2
KNM_MAT_REQ_LINE_N1 LINE_ID 3
KNM_MAT_REQ_LINE_U1 LINE_ID 1
KNM_MAT_REQ_N1 REQUEST_NUM 1
KNM_MAT_REQ_N1 INDENTING_DEPT 2
KNM_MAT_REQ_N1 TRANSACTION_TYPE 3
KNM_MAT_REQ_N1 ORGANIZATION_ID 4
KNM_MAT_REQ_U1 HEADER_ID 1
KNM_MAT_REQ_U1 REQUEST_NUM 2
KNM_MAT_REQ_U1 ORGANIZATION_ID 3
KNM_OLDADV_DTL_N1 BILL_NO 1
KNM_OLDADV_DTL_N1 HDR_ID 2
KNM_OLDADV_DTL_N1 LINE_ID 3
KNM_OLD_ADV_N1 HDR_ID 1
KNM_OLD_ADV_N1 VENDOR_ID 2
KNM_OLD_ADV_STG_N1 SL_NO 1

INDEX_NAME COLUMN_NAME COLUMN_POSITION
------------------------------ -------------------- ---------------
KNM_OLD_ADV_STG_N1 LC 2
KNM_OLD_ADV_STG_N1 CHQNO 3
KNM_OLD_ADV_STG_N1 JDATE 4
KNM_OLD_ADV_STG_N1 VCHNO 5
KNM_OLD_ADV_STG_N1 DED_NAME 6
KNM_OLD_ADV_STG_N2 LC 1
KNM_OLD_ADV_STG_N2 SL_NO 2
KNM_OLD_ADV_STG_N2 DED_NAME 3
KNM_OLD_ADV_STG_N2 NAME 4
KNM_OLD_ADV_STG_N2 BILL_NO 5
KNM_PREPAY_DTL_N1 INVOICE_ID 1
KNM_PREPAY_DTL_N1 PREPAY_INVOICE_ID 2
KNM_PREPAY_DTL_N1 ORG_ID 3
KNM_SUPP_OLD_STG_N1 SUPP_BILL_NO 1
KNM_SUPP_OLD_STG_N1 BILL_NO 2
KNM_SUPP_OLD_STG_N1 CHQNO 3
KNM_SUPP_OLD_STG_N1 CHQ_DATE 4
KNM_SUPP_OLD_STG_N1 VOUCHER_NO 5
KNM_TAX_DED_DTL_N1 LINE_ID 1
KNM_TAX_DED_DTL_N1 PO_HEADER_ID 2
KNM_TAX_DED_DTL_N1 INVOICE_ID 3

INDEX_NAME COLUMN_NAME COLUMN_POSITION
------------------------------ -------------------- ---------------
KNM_TAX_DED_DTL_N1 DEDUCTION_NAME 4
KNM_TAX_DED_N1 PO_HEADER_ID 1
KNM_TAX_DED_N1 INVOICE_ID 2
KNM_TAX_DED_N1 SUBMITTED_FLAG 3
KNM_TP_SALE_DTL_N1 PO_HEADER_ID 1
KNM_TP_SALE_DTL_N1 LINE_ID 2
KNM_TP_SALE_DTL_N1 HDR_ID 3
KNM_TP_SALE_DTL_N1 VENDOR_ID 4
KNM_TP_SALE_DTL_N1 VENDOR_SITE_ID 5
KNM_TP_SALE_HDR_N1 HDR_ID 1
KNM_TP_SALE_HDR_N1 PO_HEADER_ID 2
KNM_TP_SUP_N1 PO_HEADER_ID 1
KNM_TP_SUP_N1 VENDOR_ID 2
KNM_TP_SUP_N1 VENDOR_SITE_ID 3
KNM_VCH_UQ VOUCHER_NO 1
KNM_VCH_UQ FIN_YEAR 2
KNM_VCH_UQ VENDOR_ID 3
KNM_VOUCHER_UQ VOUCHER_NO 1
KNM_VOUCHER_UQ INVOICE_NUM 2
KNM_VOUCHER_UQ CHQ_NO 3
KNM_WORKS_HDR_N1 WORK_NO 1

INDEX_NAME COLUMN_NAME COLUMN_POSITION
------------------------------ -------------------- ---------------
KNM_WORKS_HDR_N1 EST_HEADER_ID 2
KNM_WORKS_HDR_N1 ORG_ID 3
KNM_WORKS_HDR_N1 SUBMIT_FLAG 4
KNM_WORKS_HDR_N1 EST_APPROVAL_STATUS 5
KNM_WORKS_HDR_N1 DEPARTMENT 6
KNM_WORKS_HDR_N2 WORK_NO 1
KNM_WORKS_HDR_N2 EST_HEADER_ID 2
KNM_WORKS_HDR_N3 SUBMIT_FLAG 1
KNM_WORKS_HDR_N3 WORK_NO 2
KNM_WORKS_HDR_N3 EST_HEADER_ID 3
KNM_WORKS_HDR_N4 EST_APPROVAL_STATUS 1
KNM_WORKS_HDR_N4 WORK_NAME 2
KNM_WORKS_HDR_N4 TYPE 3
KNM_WORKS_HDR_N5 WORK_NO 1
KNM_WORKS_HDR_N5 DEPARTMENT 2
KNM_WORKS_HDR_N5 BOROUGH 3
KNM_WORKS_HDR_N5 WARD 4
KNM_WORKS_HDR_N5 EST_APPROVAL_STATUS 5
KNM_WORKS_HDR_N6 DEPARTMENT 1
KNM_WORKS_HDR_N6 SUBMIT_FLAG 2
KNM_WORKS_HDR_U1 EST_HEADER_ID 1

INDEX_NAME COLUMN_NAME COLUMN_POSITION
------------------------------ -------------------- ---------------
KNM_WORKS_LINES_N1 EST_HEADER_ID 1
KNM_WORKS_LINES_N1 EST_LINE_ID 2
KNM_WORKS_LINES_N1 LINE_NUM 3
KNM_WORKS_LINES_N1 SOURCE_TYPE 4
KNM_WORKS_LINES_N1 EST_ITEM_ID 5
KNM_WORKS_LINES_N1 ORGANIZATION_ID 6
KNM_WORKS_LINES_U1 EST_LINE_ID 1
KNM_WORKS_LINES_U1 SOURCE_TYPE 2

133 rows selected

SQL>