VIEW: SYS._ALL_REPGROUPED_COLUMN

Source

View Text - Preformatted

select
  gc.sname, gc.oname, gc.group_name,
  gc.column_name,
  gc.pos
from all_tab_columns tc, system.repcat$_grouped_column gc
where gc.sname = tc.owner
  and gc.oname = tc.table_name
  and (gc.column_name = tc.column_name OR
       (gc.column_name = 'SYS_NC_OID$' AND
        -- sOID column
        exists (select 1 from system.repcat$_repcolumn rc
                  where rc.sname = gc.sname
                    and rc.oname = gc.oname
                    and rc.cname = 'SYS_NC_OID$'
                    and utl_raw.bit_and(utl_raw.substr(rc.property, 1, 1),
                          '10') = '10')))
union
select
  gc.sname, gc.oname, gc.group_name,
  gc.column_name,
  gc.pos
from "_ALL_REPL_NESTED_TABLE_NAMES" nt, system.repcat$_grouped_column gc
where gc.sname = nt.owner
  and gc.oname = nt.table_name

View Text - HTML Formatted

SELECT GC.SNAME
, GC.ONAME
, GC.GROUP_NAME
, GC.COLUMN_NAME
, GC.POS FROM ALL_TAB_COLUMNS TC
, SYSTEM.REPCAT$_GROUPED_COLUMN GC WHERE GC.SNAME = TC.OWNER
AND GC.ONAME = TC.TABLE_NAME
AND (GC.COLUMN_NAME = TC.COLUMN_NAME OR (GC.COLUMN_NAME = 'SYS_NC_OID$' AND -- SOID COLUMN EXISTS (SELECT 1
FROM SYSTEM.REPCAT$_REPCOLUMN RC
WHERE RC.SNAME = GC.SNAME
AND RC.ONAME = GC.ONAME
AND RC.CNAME = 'SYS_NC_OID$'
AND UTL_RAW.BIT_AND(UTL_RAW.SUBSTR(RC.PROPERTY
, 1
, 1)
, '10') = '10'))) UNION SELECT GC.SNAME
, GC.ONAME
, GC.GROUP_NAME
, GC.COLUMN_NAME
, GC.POS FROM "_ALL_REPL_NESTED_TABLE_NAMES" NT
, SYSTEM.REPCAT$_GROUPED_COLUMN GC WHERE GC.SNAME = NT.OWNER
AND GC.ONAME = NT.TABLE_NAME