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

1 vote210 views1 answer
Reutrn string after character sql
SQL
1 vote222 views1 answer
Load sql into mamp
SQL
0 vote236 views1 answer
Oracle locked objects
SQL
1 vote257 views1 answer
Mamp mysql path mac
SQL
4 votes205 views2 answers
Oracle set date format
SQL
0 vote245 views1 answer
How to delete python anywhere mysql database
SQL
0 vote230 views1 answer
Where name ends in SQL
SQL
1 vote232 views4 answers
Sequelize migration default value
SQL
3 votes247 views3 answers
Mysql auto increment after delete
SQL
13 votes175 views2 answers
Oracle all source
SQL