VIEW: SYS.LOGSTDBY_SUPPORT_SEQ

Source

View Text - Preformatted

select u.name owner, o.name name, o.type#, o.obj#,
         decode(bitand(s.flags, 8), 8, 1, 0) current_sby,
         nvl((select 2 from system.logstdby$skip_support s3
              where s3.name = u.name and s3.name2 = o.name
                and s3.action = -2),
             nvl((select 0 from system.logstdby$skip_support s2
                  where s2.name = u.name and action = 0), 1)) gensby
  from obj$ o, user$ u, seq$ s
  where o.owner# = u.user#
  and o.obj# = s.obj#

View Text - HTML Formatted

SELECT U.NAME OWNER
, O.NAME NAME
, O.TYPE#
, O.OBJ#
, DECODE(BITAND(S.FLAGS
, 8)
, 8
, 1
, 0) CURRENT_SBY
, NVL((SELECT 2
FROM SYSTEM.LOGSTDBY$SKIP_SUPPORT S3
WHERE S3.NAME = U.NAME
AND S3.NAME2 = O.NAME
AND S3.ACTION = -2)
, NVL((SELECT 0
FROM SYSTEM.LOGSTDBY$SKIP_SUPPORT S2
WHERE S2.NAME = U.NAME
AND ACTION = 0)
, 1)) GENSBY
FROM OBJ$ O
, USER$ U
, SEQ$ S
WHERE O.OWNER# = U.USER#
AND O.OBJ# = S.OBJ#