Answers for "oracle show index columns"

SQL
0

oracle show index columns

SELECT TABLE_NAME, INDEX_NAME, COLUMN_NAME
FROM DBA_IND_COLUMNS			-- or ALL_IND_COLUMNS
WHERE TABLE_OWNER = 'MY_SCHEMA' AND TABLE_NAME = 'MY_TABLE'
ORDER BY TABLE_NAME, COLUMN_POSITION;
Posted by: Guest on May-06-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language