[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')