select
sname,
oname,
decode(conflict_type_id,
1, 'UPDATE',
2, 'UNIQUENESS',
3, 'DELETE',
'UNDEFINED'),
reference_name,
sequence_no,
method_name,
function_name,
priority_group,
resolution_comment
from system.repcat$_resolution
SELECT
SNAME
,
ONAME
,
DECODE(CONFLICT_TYPE_ID
,
1
, 'UPDATE'
,
2
, 'UNIQUENESS'
,
3
, 'DELETE'
,
'UNDEFINED')
,
REFERENCE_NAME
,
SEQUENCE_NO
,
METHOD_NAME
,
FUNCTION_NAME
,
PRIORITY_GROUP
,
RESOLUTION_COMMENT
FROM SYSTEM.REPCAT$_RESOLUTION
|
|
|