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
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
|
|
|