DBA Data[Home] [Help]

VIEW: SYS.ALL_REPPRIORITY_GROUP

Source

View Text - Preformatted

select
    sname,
    priority_group,
    decode(data_type_id,
           1, 'NUMBER',
           2, 'VARCHAR2',
           3, 'DATE',
           4, 'CHAR',
           5, 'RAW',
           6, 'NVARCHAR2',
           7, 'NCHAR',
           'UNDEFINED'),
    fixed_data_length,
    priority_comment,
    sname
from  system.repcat$_priority_group
View Text - HTML Formatted

SELECT SNAME
, PRIORITY_GROUP
, DECODE(DATA_TYPE_ID
, 1
, 'NUMBER'
, 2
, 'VARCHAR2'
, 3
, 'DATE'
, 4
, 'CHAR'
, 5
, 'RAW'
, 6
, 'NVARCHAR2'
, 7
, 'NCHAR'
, 'UNDEFINED')
, FIXED_DATA_LENGTH
, PRIORITY_COMMENT
, SNAME FROM SYSTEM.REPCAT$_PRIORITY_GROUP