VIEW: SYS.DBA_SCHEDULER_WINDOW_GROUPS

Source

View Text - Preformatted

SELECT o.name, DECODE(BITAND(w.flags,1),0,'FALSE',1,'TRUE'),
    (SELECT COUNT(*) FROM scheduler$_wingrp_member wg WHERE wg.oid = w.obj#),
    DECODE(BITAND(w.flags,1),0,'NULL',1,
     (SELECT min(next_start_date) FROM scheduler$_window win WHERE win.obj# IN
      (SELECT wgm.member_oid FROM scheduler$_wingrp_member wgm
        WHERE wgm.oid = w.obj#) AND bitand(win.flags, 1) = 1)),
    w.comments
  FROM obj$ o, scheduler$_window_group w WHERE o.obj# = w.obj#
   AND bitand(w.flags, 8+16) = 0

View Text - HTML Formatted

SELECT O.NAME
, DECODE(BITAND(W.FLAGS
, 1)
, 0
, 'FALSE'
, 1
, 'TRUE')
, (SELECT COUNT(*)
FROM SCHEDULER$_WINGRP_MEMBER WG
WHERE WG.OID = W.OBJ#)
, DECODE(BITAND(W.FLAGS
, 1)
, 0
, 'NULL'
, 1
, (SELECT MIN(NEXT_START_DATE)
FROM SCHEDULER$_WINDOW WIN
WHERE WIN.OBJ# IN (SELECT WGM.MEMBER_OID
FROM SCHEDULER$_WINGRP_MEMBER WGM
WHERE WGM.OID = W.OBJ#)
AND BITAND(WIN.FLAGS
, 1) = 1))
, W.COMMENTS
FROM OBJ$ O
, SCHEDULER$_WINDOW_GROUP W
WHERE O.OBJ# = W.OBJ#
AND BITAND(W.FLAGS
, 8+16) = 0