DBA Data[Home] [Help]

VIEW: SYS.USER_REPAUDIT_ATTRIBUTE

Source

View Text - Preformatted

select
    attribute,
    decode(data_type_id,
           1, 'NUMBER',
           2, 'VARCHAR2',
           3, 'DATE',
           4, 'CHAR',
           5, 'RAW',
           6, 'NVARCHAR2',
           7, 'NCHAR',
           'UNDEFINED'),
    data_length,
    source
from  system.repcat$_audit_attribute
View Text - HTML Formatted

SELECT ATTRIBUTE
, DECODE(DATA_TYPE_ID
, 1
, 'NUMBER'
, 2
, 'VARCHAR2'
, 3
, 'DATE'
, 4
, 'CHAR'
, 5
, 'RAW'
, 6
, 'NVARCHAR2'
, 7
, 'NCHAR'
, 'UNDEFINED')
, DATA_LENGTH
, SOURCE FROM SYSTEM.REPCAT$_AUDIT_ATTRIBUTE