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
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
|
|
|