/SQL/Lister les index d'une table oracle

Lister les index d'une 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

5 votes191 views6 answers
Sql add days to date
SQL
0 vote207 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote209 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
7 votes188 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
1 vote216 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
15 votes215 views5 answers
If null mysql
SQL
0 vote200 views1 answer
Alter table name including schema
SQL
9 votes194 views4 answers
Mysql show table fields
SQL
0 vote229 views1 answer
Mysql disable triggers
SQL
3 votes198 views1 answer
Sql cast to integer
SQL