VIEW: SYS.USER_REPGROUPED_COLUMN

Source

View Text - Preformatted

select
    g.oname,
    g.group_name,
    g.column_name
from  user_tab_columns tc, sys.dba_repgrouped_column g, sys.user$ u
where g.sname = u.name
  and u.user# = userenv('SCHEMAID')
  and g.oname = tc.table_name
  and g.column_name = tc.column_name
union
select
    g.oname,
    g.group_name,
    g.column_name
from  "_USER_REPL_NESTED_TABLE_NAMES" nt, sys.dba_repgrouped_column g,
      sys.user$ u
where g.sname = u.name
  and u.user# = userenv('SCHEMAID')
  and g.oname = nt.table_name

View Text - HTML Formatted

SELECT G.ONAME
, G.GROUP_NAME
, G.COLUMN_NAME FROM USER_TAB_COLUMNS TC
, SYS.DBA_REPGROUPED_COLUMN G
, SYS.USER$ U WHERE G.SNAME = U.NAME
AND U.USER# = USERENV('SCHEMAID')
AND G.ONAME = TC.TABLE_NAME
AND G.COLUMN_NAME = TC.COLUMN_NAME UNION SELECT G.ONAME
, G.GROUP_NAME
, G.COLUMN_NAME FROM "_USER_REPL_NESTED_TABLE_NAMES" NT
, SYS.DBA_REPGROUPED_COLUMN G
, SYS.USER$ U WHERE G.SNAME = U.NAME
AND U.USER# = USERENV('SCHEMAID')
AND G.ONAME = NT.TABLE_NAME