VIEW: SYS.ALL_CLUSTERING_KEYS

Source

View Text - Preformatted

select k.owner, k.table_name, k.detail_owner, k.detail_name, k.detail_column,
       k.position, k.groupid
from   DBA_CLUSTERING_KEYS k, ALL_TABLES t
WHERE  k.OWNER = t.OWNER
AND    k.TABLE_NAME = t.TABLE_NAME

View Text - HTML Formatted

SELECT K.OWNER
, K.TABLE_NAME
, K.DETAIL_OWNER
, K.DETAIL_NAME
, K.DETAIL_COLUMN
, K.POSITION
, K.GROUPID FROM DBA_CLUSTERING_KEYS K
, ALL_TABLES T WHERE K.OWNER = T.OWNER AND K.TABLE_NAME = T.TABLE_NAME