[Home] [Help]
VIEW: SYS.DBA_SUBSCRIPTIONS
Source
View Text - Preformatted
SELECT
s.handle, s.set_name, s.username, s.created, s.status, s.earliest_scn,
s.latest_scn, s.description, s.last_purged, s.last_extended,
s.subscription_name
FROM sys.cdc_subscribers$ s
View Text - HTML Formatted
SELECT
S.HANDLE
, S.SET_NAME
, S.USERNAME
, S.CREATED
, S.STATUS
, S.EARLIEST_SCN
,
S.LATEST_SCN
, S.DESCRIPTION
, S.LAST_PURGED
, S.LAST_EXTENDED
,
S.SUBSCRIPTION_NAME
FROM SYS.CDC_SUBSCRIBERS$ S