colgroups.sql
---------------------------------------------------------------------------
-- Filename: colgroups.sql
-- Purpose: Lists all defined column groups.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 27-May-1998
---------------------------------------------------------------------------
column sname heading "Schema|Name" format a8
column oname heading "Table|Name" format a30
column group_name heading "Column|Group" format a30
column group_comment heading "Comment" format a19
SELECT sname,
oname,
group_name
FROM dba_repcolumn_group
ORDER BY sname, oname, group_name
/Get Oracle Distributed Systems now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
