GET A ALL INDEX NAME

GET A ALL INDEX NAME:-


SELECT c.table_owner,c.table_name, i.index_name,
DECODE(i.uniqueness, 'UNIQUE', 'YES', 'NO') UNIQUENESS,
c.column_name, c.column_position, i.tablespace_name
FROM dba_ind_columns c, dba_indexes i
WHERE i.index_name = c.index_name
AND i.table_owner = c.table_owner
AND i.uniqueness='UNIQUE'
AND C.TABLE_NAME IN('FND_TIMEZONES_B','FND_TIMEZONES_TL','HZ_CODE_ASSIGNMENTS','HZ_CUST_ACCT_SITES_ALL','HZ_CUST_PROFILE_CLASSES','HZ_CUSTOMER_PROFILES','HZ_TIMEZONES','RA_CUST_TRX_LINE_GL_DIST_ALL',
'RA_CUST_TRX_LINE_GL_DIST_ALL','RA_GROUPING_RULES','RA_MC_CUSTOMER_TRX','RA_MC_TRX_LINE_GL_DIST','XLA_EVENT_CLASS_ATTRS')
ORDER BY c.table_owner,c.table_name,c.index_owner, i.index_name, c.column_position