DBA Data[Home] [Help]

VIEW: SYS.USER_CLUSTERING_KEYS

Source

View Text - Preformatted

select owner, table_name, detail_owner, detail_name, detail_column,
       position, groupid
from DBA_CLUSTERING_KEYS
WHERE owner = SYS_CONTEXT('USERENV','CURRENT_USER')
View Text - HTML Formatted

SELECT OWNER
, TABLE_NAME
, DETAIL_OWNER
, DETAIL_NAME
, DETAIL_COLUMN
, POSITION
, GROUPID FROM DBA_CLUSTERING_KEYS WHERE OWNER = SYS_CONTEXT('USERENV'
, 'CURRENT_USER')