VIEW: SYS.DBA_SCHEDULER_DB_DESTS

Source

View Text - Preformatted

SELECT u.name, o.name, d.connect_info, ao.name,
  decode(bitand(d.flags, 1), 1, 'TRUE', 'FALSE'),
  decode(bitand(ad.flags, 1), 1, 'TRUE', 'FALSE'),
  d.comments
FROM user$ u, obj$ o, scheduler$_destinations d, obj$ ao,
     scheduler$_destinations ad
WHERE u.user# = o.owner# AND o.obj# = d.obj# AND
  d.agtdestoid = ao.obj#(+) AND bitand(d.flags, 4+8) = 4
  AND d.agtdestoid = ad.obj#(+)

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, D.CONNECT_INFO
, AO.NAME
, DECODE(BITAND(D.FLAGS
, 1)
, 1
, 'TRUE'
, 'FALSE')
, DECODE(BITAND(AD.FLAGS
, 1)
, 1
, 'TRUE'
, 'FALSE')
, D.COMMENTS FROM USER$ U
, OBJ$ O
, SCHEDULER$_DESTINATIONS D
, OBJ$ AO
, SCHEDULER$_DESTINATIONS AD WHERE U.USER# = O.OWNER#
AND O.OBJ# = D.OBJ# AND D.AGTDESTOID = AO.OBJ#(+)
AND BITAND(D.FLAGS
, 4+8) = 4
AND D.AGTDESTOID = AD.OBJ#(+)