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 vote221 views1 answer
Providername system.data. mysql
SQL
8 votes221 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL
3 votes210 views2 answers
Mysql create timestamp column
SQL
0 vote192 views1 answer
Postgres 11 add primary key
SQL
4 votes221 views5 answers
Get last query in codeigniter 4
SQL
1 vote202 views1 answer
Mysql select update same table
SQL
0 vote209 views1 answer
Sql server on mac m1
SQL
0 vote208 views1 answer
Close sql query vb.net
SQL
1 vote198 views2 answers
Mysql join two tables
SQL
0 vote197 views1 answer
Assign value to var in SQL
SQL