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

0 vote334 views2 answers
Sqlalchemy core in clause
SQL
0 vote324 views1 answer
Monthly Birthday SQL Query
SQL
0 vote343 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote328 views1 answer
Max mysql
SQL
0 vote322 views1 answer
How to close external sql connection in laravel
SQL
0 vote321 views1 answer
Mysql change timestamp on update
SQL
7 votes376 views1 answer
Buy forge mods server hosting
SQL
5 votes348 views2 answers
Mysqldump password
SQL
14 votes379 views6 answers
Finding duplicate rows mysql
SQL
2 votes364 views1 answer
Creating a view SQL
SQL