VIEW: SYS.DBA_REPPRIORITY

Source

View Text - Preformatted

select
    p.sname,
    p.priority_group,
    v.priority,
    decode(p.data_type_id,
           1, 'NUMBER',
           2, 'VARCHAR2',
           3, 'DATE',
           4, 'CHAR',
           5, 'RAW',
           6, 'NVARCHAR2',
           7, 'NCHAR',
           'UNDEFINED'),
    p.fixed_data_length,
    v.char_value,
    v.varchar2_value,
    v.number_value,
    v.date_value,
    v.raw_value,
    p.sname,
    v.nchar_value,
    v.nvarchar2_value,
    v.large_char_value
from  system.repcat$_priority v,
      system.repcat$_priority_group p
where v.sname = p.sname
and   v.priority_group = p.priority_group

View Text - HTML Formatted

SELECT P.SNAME
, P.PRIORITY_GROUP
, V.PRIORITY
, DECODE(P.DATA_TYPE_ID
, 1
, 'NUMBER'
, 2
, 'VARCHAR2'
, 3
, 'DATE'
, 4
, 'CHAR'
, 5
, 'RAW'
, 6
, 'NVARCHAR2'
, 7
, 'NCHAR'
, 'UNDEFINED')
, P.FIXED_DATA_LENGTH
, V.CHAR_VALUE
, V.VARCHAR2_VALUE
, V.NUMBER_VALUE
, V.DATE_VALUE
, V.RAW_VALUE
, P.SNAME
, V.NCHAR_VALUE
, V.NVARCHAR2_VALUE
, V.LARGE_CHAR_VALUE FROM SYSTEM.REPCAT$_PRIORITY V
, SYSTEM.REPCAT$_PRIORITY_GROUP P WHERE V.SNAME = P.SNAME AND V.PRIORITY_GROUP = P.PRIORITY_GROUP