VIEW: SYS.ALL_REPGROUPED_COLUMN

Source

View Text - Preformatted

select
    g.sname,
    g.oname,
    g.group_name,
    g.column_name
from all_tab_columns tc, sys.dba_repgrouped_column g
where g.sname = tc.owner
  and g.oname = tc.table_name
  and g.column_name = tc.column_name
union
select
    g.sname,
    g.oname,
    g.group_name,
    g.column_name
from "_ALL_REPL_NESTED_TABLE_NAMES" nt, sys.dba_repgrouped_column g
where g.sname = nt.owner
  and g.oname = nt.table_name

View Text - HTML Formatted

SELECT G.SNAME
, G.ONAME
, G.GROUP_NAME
, G.COLUMN_NAME FROM ALL_TAB_COLUMNS TC
, SYS.DBA_REPGROUPED_COLUMN G WHERE G.SNAME = TC.OWNER
AND G.ONAME = TC.TABLE_NAME
AND G.COLUMN_NAME = TC.COLUMN_NAME UNION SELECT G.SNAME
, G.ONAME
, G.GROUP_NAME
, G.COLUMN_NAME FROM "_ALL_REPL_NESTED_TABLE_NAMES" NT
, SYS.DBA_REPGROUPED_COLUMN G WHERE G.SNAME = NT.OWNER
AND G.ONAME = NT.TABLE_NAME