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 vote356 views1 answer
Insert results of a stored procedure into a temporary table
SQL
0 vote343 views1 answer
Turn on foreign keys check mysql
SQL
1 vote308 views1 answer
Insert into sql
SQL
1 vote328 views1 answer
Mysql average of multiple columns
SQL
0 vote365 views1 answer
Mariadb cast null to 0
SQL
19 votes356 views6 answers
Sql create table
SQL
0 vote363 views1 answer
When mysql server would not work in xampp
SQL
2 votes360 views2 answers
Sql percentage
SQL
7 votes377 views5 answers
Oracle alter table
SQL
0 vote360 views1 answer
Where date in datetime mysql
SQL