April 1999
Intermediate to advanced
552 pages
15h 39m
English
---------------------------------------------------------------------------
-- Filename: prioritygroups.sql
-- Purpose: Lists all defined priority groups.
-- Author: Chas. Dye (cdye@excitecorp.com)
-- Date: 27-May-1998
---------------------------------------------------------------------------
column sname heading "Rep|Group" format a15
column priority_group heading "Priority|Group" format a15
column data_type heading "Data|Type" format a9
column priority_comment heading "Comment" format a35
SELECT sname,
priority_group,
data_type,
substr(priority_comment, 1, 35) priority_comment
FROM dba_reppriority_group
ORDER BY sname, priority_group
/