VIEW: SYS.KU$_IDCOL_SEQ_VIEW

Source

View Text - Preformatted

select '1','1',
         s.obj#, value(o),
         s.increment$, TO_CHAR(s.minvalue), TO_CHAR(s.maxvalue),
         s.cycle#, s.order$, s.cache,
         TO_CHAR(s.highwater),  replace(s.audit$,chr(0),'-'), s.flags,
         s.partcount
  from  sys.ku$_schemaobj_view o, sys.seq$ s
  where s.obj# = o.obj_num AND
        (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0) OR
         EXISTS ( SELECT * FROM sys.session_roles
         WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '1'
, S.OBJ#
, VALUE(O)
, S.INCREMENT$
, TO_CHAR(S.MINVALUE)
, TO_CHAR(S.MAXVALUE)
, S.CYCLE#
, S.ORDER$
, S.CACHE
, TO_CHAR(S.HIGHWATER)
, REPLACE(S.AUDIT$
, CHR(0)
, '-')
, S.FLAGS
, S.PARTCOUNT
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.SEQ$ S
WHERE S.OBJ# = O.OBJ_NUM AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))