Oracle list index on table

SELECT *
FROM ALL_INDEXES		-- or DBA_INDEXES or USER_INDEXES
WHERE TABLE_NAME = 'MY_TABLE' AND OWNER = 'MY_OWNER';

-- Index columns
SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME
FROM DBA_IND_COLUMNS
WHERE TABLE_OWNER = 'MY_OWNER' AND TABLE_NAME = 'MY_TABLE'
ORDER BY TABLE_NAME, COLUMN_POSITION;

Similar codes

6 votes304 views1 answer
Update left join mysql
SQL
0 vote303 views1 answer
Select list is not in group by clause and contains nonaggregated column codeigniter
SQL
0 vote320 views1 answer
How to access to mysql without root
SQL
4 votes301 views2 answers
Error loading MySQLdb module.
SQL
0 vote340 views1 answer
Sql missing values
SQL
0 vote326 views1 answer
Sql count matching group by
SQL
0 vote315 views1 answer
Sql trigger to call stored procedure with parameters
SQL
0 vote317 views1 answer
Power bi union columns
SQL
0 vote311 views1 answer
Ignore case in string sql
SQL
0 vote312 views2 answers
How to type a blank discord messgae
SQL