select
sname,
oname,
decode(conflict_type_id,
1, 'UPDATE',
2, 'UNIQUENESS',
3, 'DELETE',
'UNDEFINED'),
reference_name,
method_name,
decode(method_name,
'USER FUNCTION', function_name,
'USER FLAVOR FUNCTION', function_name,
NULL),
priority_group,
resolved_date,
primary_key_value
from system.repcat$_resolution_statistics
SELECT
SNAME
,
ONAME
,
DECODE(CONFLICT_TYPE_ID
,
1
, 'UPDATE'
,
2
, 'UNIQUENESS'
,
3
, 'DELETE'
,
'UNDEFINED')
,
REFERENCE_NAME
,
METHOD_NAME
,
DECODE(METHOD_NAME
,
'USER FUNCTION'
, FUNCTION_NAME
,
'USER FLAVOR FUNCTION'
, FUNCTION_NAME
,
NULL)
,
PRIORITY_GROUP
,
RESOLVED_DATE
,
PRIMARY_KEY_VALUE
FROM SYSTEM.REPCAT$_RESOLUTION_STATISTICS
|
|
|