Get index in table in Oracle Database

How to get index in table in Oracle Database

For user

set linesize 190

col index_name for a40

col column_name for a40

SELECT index_name, column_name, column_position FROM user_ind_columns WHERE table_name = '&t_name' ORDER BY index_name;

select distinct(index_name) FROM user_ind_columns WHERE table_name = '&t_name' ORDER BY index_name, column_position;

For sys user

set linesize 190

col index_name for a40

col column_name for a40

SELECT index_name, column_name, column_position FROM dba_ind_columns WHERE table_name = '&t_name' ORDER BY index_name, column_position;

select distinct(index_name) FROM dba_ind_columns WHERE table_name = '&t_name' ORDER BY index_name;