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 vote143 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote168 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote154 views1 answer
Mysql 8 error on identified by
SQL
0 vote154 views1 answer
Sql script to remove default from column
SQL
-1 vote158 views1 answer
Adding a new table psql
SQL
0 vote159 views1 answer
Select year from dual oracle
SQL
6 votes142 views2 answers
Oracle undotbs usage
SQL
0 vote158 views1 answer
Enable sql server full text indexing
SQL
0 vote172 views1 answer
Finding leap year in sql
SQL
8 votes183 views1 answer
Racle create auto increment column
SQL