April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- 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
/