DBA Data[Home] [Help]

VIEW: SYS.GV_$INDEXED_FIXED_COLUMN

Source

View Text - Preformatted

select "INST_ID","TABLE_NAME","INDEX_NUMBER","COLUMN_NAME","COLUMN_POSITION","CON_ID" from gv$indexed_fixed_column
View Text - HTML Formatted

SELECT "INST_ID"
, "TABLE_NAME"
, "INDEX_NUMBER"
, "COLUMN_NAME"
, "COLUMN_POSITION"
, "CON_ID"
FROM GV$INDEXED_FIXED_COLUMN