VIEW: SYS.USER_SEQUENCES

Source

View Text - Preformatted

select o.name,
      s.minvalue, s.maxvalue, s.increment$,
      decode (s.cycle#, 0, 'N', 1, 'Y'),
      decode (s.order$, 0, 'N', 1, 'Y'),
      s.cache, s.highwater,
      decode (s.partcount, 0, to_number(NULL), s.partcount),
      decode(bitand(s.flags, 64), 64, 'Y', 'N'),
      decode(bitand(s.flags, 512), 512, 'Y', 'N')
from sys.seq$ s, sys.obj$ o
where o.owner# = userenv('SCHEMAID')
  and o.obj# = s.obj#

View Text - HTML Formatted

SELECT O.NAME
, S.MINVALUE
, S.MAXVALUE
, S.INCREMENT$
, DECODE (S.CYCLE#
, 0
, 'N'
, 1
, 'Y')
, DECODE (S.ORDER$
, 0
, 'N'
, 1
, 'Y')
, S.CACHE
, S.HIGHWATER
, DECODE (S.PARTCOUNT
, 0
, TO_NUMBER(NULL)
, S.PARTCOUNT)
, DECODE(BITAND(S.FLAGS
, 64)
, 64
, 'Y'
, 'N')
, DECODE(BITAND(S.FLAGS
, 512)
, 512
, 'Y'
, 'N') FROM SYS.SEQ$ S
, SYS.OBJ$ O WHERE O.OWNER# = USERENV('SCHEMAID')
AND O.OBJ# = S.OBJ#