DBA Data[Home] [Help]

VIEW: SYS._ALL_REPCOLUMN_GROUP

Source

View Text - Preformatted

select /*+ ALL_ROWS */ distinct cg.sname, cg.oname, cg.group_name,
 cg.group_comment
  from all_repcolumn_group cg, "_ALL_REPGROUPED_COLUMN" rcgcol
 where cg.group_name = rcgcol.group_name
      and cg.sname = rcgcol.sname
      and cg.oname = rcgcol.oname
View Text - HTML Formatted

SELECT /*+ ALL_ROWS */ DISTINCT CG.SNAME
, CG.ONAME
, CG.GROUP_NAME
, CG.GROUP_COMMENT
FROM ALL_REPCOLUMN_GROUP CG
, "_ALL_REPGROUPED_COLUMN" RCGCOL
WHERE CG.GROUP_NAME = RCGCOL.GROUP_NAME
AND CG.SNAME = RCGCOL.SNAME
AND CG.ONAME = RCGCOL.ONAME