VIEW: SYS.USER_SCHEDULER_DB_DESTS

Source

View Text - Preformatted

SELECT 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 obj$ o, scheduler$_destinations d, obj$ ao,
       scheduler$_destinations ad
WHERE o.owner# = userenv('SCHEMAID') 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 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 OBJ$ O
, SCHEDULER$_DESTINATIONS D
, OBJ$ AO
, SCHEDULER$_DESTINATIONS AD WHERE O.OWNER# = USERENV('SCHEMAID')
AND O.OBJ# = D.OBJ# AND D.AGTDESTOID = AO.OBJ#(+)
AND BITAND(D.FLAGS
, 4+8) = 4
AND D.AGTDESTOID = AD.OBJ#(+)