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 vote216 views2 answers
Oracle create chain rule
SQL
0 vote259 views1 answer
Hibernate dialect property xml for mysql 8
SQL
1 vote237 views1 answer
Dropping a constraint in ms sql
SQL
7 votes204 views1 answer
Sql management studio display line numbers
SQL
7 votes233 views3 answers
How ot change name of column mysql
SQL
0 vote212 views1 answer
Oracle call a function in a insert statement
SQL
0 vote232 views1 answer
Write a query to peint the pattern P(20)
SQL
0 vote240 views1 answer
Postgres - Login and connect as default user
SQL
0 vote201 views2 answers
Sql select inside select
SQL
0 vote215 views1 answer
SQL Query to delete all the tables in a database
SQL