[Home] [Help]
select
r.oname,
decode(r.conflict_type_id,
1, 'UPDATE',
2, 'UNIQUENESS',
3, 'DELETE',
'UNDEFINED'),
r.reference_name
from system.repcat$_conflict r, user$ u
where r.sname = u.name
and u.user# = userenv('SCHEMAID')
SELECT
R.ONAME
,
DECODE(R.CONFLICT_TYPE_ID
,
1
, 'UPDATE'
,
2
, 'UNIQUENESS'
,
3
, 'DELETE'
,
'UNDEFINED')
,
R.REFERENCE_NAME
FROM SYSTEM.REPCAT$_CONFLICT R
, USER$ U
WHERE R.SNAME = U.NAME
AND U.USER# = USERENV('SCHEMAID')
|
|
|
|