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 vote213 views1 answer
Add new column in sql with foreign key
SQL
0 vote234 views1 answer
Find duplicate users by email address in mysql
SQL
1 vote188 views2 answers
Mysql remove first and last character from string
SQL
0 vote221 views1 answer
Psql store procedure-return multiple table values
SQL
0 vote200 views1 answer
Postgresql import a database of gzip
SQL
0 vote243 views1 answer
Sql server python connection
SQL
0 vote272 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
4 votes188 views2 answers
Oracle default date format
SQL
0 vote190 views1 answer
Get who is hired in january in sql
SQL
0 vote190 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL