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 vote130 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote122 views1 answer
Create query in where clasue
SQL
2 votes109 views1 answer
Sqlite show table indexes
SQL
0 vote98 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL
0 vote169 views1 answer
Import sql dump into postgresql database
SQL
0 vote110 views1 answer
C# get sql min date
SQL
10 votes113 views2 answers
Mysql alter add foreign key
SQL
11 votes110 views6 answers
Mysql else if
SQL
3 votes101 views1 answer
DB: in eloquent using sql
SQL
0 vote103 views1 answer
What is logical database schema
SQL