select
sname,
oname,
created,
decode(status,
1, 'ACTIVE',
2, 'CANCELLED',
'UNDEFINED'),
status_update_date,
purged_date,
last_purge_start_date,
last_purge_end_date
from system.repcat$_resol_stats_control
SELECT
SNAME
,
ONAME
,
CREATED
,
DECODE(STATUS
,
1
, 'ACTIVE'
,
2
, 'CANCELLED'
,
'UNDEFINED')
,
STATUS_UPDATE_DATE
,
PURGED_DATE
,
LAST_PURGE_START_DATE
,
LAST_PURGE_END_DATE
FROM SYSTEM.REPCAT$_RESOL_STATS_CONTROL
|
|
|