prioritysites.sql
---------------------------------------------------------------------------
-- Filename: prioritysites.sql
-- Purpose: Lists all defined priority sites.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 27-May-1998
---------------------------------------------------------------------------
column sname heading "Rep|Group" format a15
column priority_group heading "Site|Priority|Name" format a15
column priority heading "Priority" format 9999
column varchar2_value heading "Site|Name" format a20
column priority_comment heading "Comment" format a35
SELECT sname,
priority_group,
varchar2_value,
priority
FROM dba_reppriority
ORDER BY sname, priority_group
/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.
