DBA Data[Home] [Help]

VIEW: SYS.ALL_REPCOLUMN_GROUP

Source

View Text - Preformatted

select
    c.sname,
    c.oname,
    c.group_name,
    c.group_comment
from system.repcat$_column_group c, all_repobject o
  where c.sname = o.sname and c.oname = o.oname
    and o.type in ('TABLE', 'SNAPSHOT')
View Text - HTML Formatted

SELECT C.SNAME
, C.ONAME
, C.GROUP_NAME
, C.GROUP_COMMENT FROM SYSTEM.REPCAT$_COLUMN_GROUP C
, ALL_REPOBJECT O
WHERE C.SNAME = O.SNAME
AND C.ONAME = O.ONAME
AND O.TYPE IN ('TABLE'
, 'SNAPSHOT')