Select index table oracle

How to select an index in oracle sql

SELECT  *
FROM    all_indexes
WHERE   table_name = 'COUNTRY';

Source: stackoverflow.com

Select index table oracle

SELECT *
FROM ALL_INDEXES			-- or DBA_INDEXES or USER_INDEXES
WHERE TABLE_NAME = 'MY_TABLE' AND OWNER = 'MY_OWNER';

-- Indexes columns
SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME
FROM DBA_IND_COLUMNS		-- or ALL_IND_COLUMNS
WHERE TABLE_OWNER = 'MY_OWNER' AND TABLE_NAME = 'MY_TABLE'
ORDER BY TABLE_NAME, COLUMN_POSITION;

Similar codes

4 votes134 views2 answers
Truncate oracle
SQL
-1 vote139 views1 answer
Select first rows postgresql
SQL
13 votes142 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
16 votes140 views4 answers
Ascending order mysql
SQL
-1 vote149 views4 answers
Restart mysql server ubuntu
SQL
0 vote156 views1 answer
Sql query for login with email or username
SQL
1 vote144 views1 answer
Postgres convert exisiting column to text
SQL
0 vote108 views1 answer
Mysql offset from bottom
SQL
0 vote99 views1 answer
Como leer datos de mysql esp32
SQL
0 vote136 views1 answer
T-sql email validation
SQL