Query To Find Index Name and Index Column Name on Oracle Table
SELECT
SUBSTR(INDEX_NAME,1,30) INDEX_NM,
TABLE_NAME TABLE_NM,
COLUMN_NAME COLUMN_NM,COLUMN_POSITION
FROM ALL_IND_COLUMNS
WHERE TABLE_NAME =UPPER('&TABLE_NAME')
ORDER BY INDEX_NAME,COLUMN_POSITION
No comments:
Post a Comment