VIEW: SYS.USER_TAB_IDENTITY_COLS

Source

View Text - Preformatted

select o.name, c.name,
       decode(bitand(c.property, 137438953472 + 274877906944),
                     137438953472, 'ALWAYS',
                     274877906944, 'BY DEFAULT'),
       so.name,
       'START WITH: '     || i.startwith ||
       ', INCREMENT BY: ' || s.increment$ ||
       ', MAX_VALUE: '    || s.maxvalue ||
       ', MIN_VALUE: '    || s.minvalue ||
       ', CYCLE_FLAG: '   || decode (s.cycle#, 0, 'N', 1, 'Y') ||
       ', CACHE_SIZE: '   || s.cache ||
       ', ORDER_FLAG: '   || decode (s.order$, 0, 'N', 1, 'Y')
from sys.idnseq$ i, sys.obj$ o, sys.col$ c,
     sys.seq$ s, sys.obj$ so
where o.owner# = userenv('SCHEMAID')
and o.obj# = i.obj#
and c.intcol# = i.intcol#
and c.obj# = i.obj#
and s.obj# = i.seqobj#
and so.obj# = i.seqobj#

View Text - HTML Formatted

SELECT O.NAME
, C.NAME
, DECODE(BITAND(C.PROPERTY
, 137438953472 + 274877906944)
, 137438953472
, 'ALWAYS'
, 274877906944
, 'BY DEFAULT')
, SO.NAME
, 'START WITH: ' || I.STARTWITH || '
, INCREMENT BY: ' || S.INCREMENT$ || '
, MAX_VALUE: ' || S.MAXVALUE || '
, MIN_VALUE: ' || S.MINVALUE || '
, CYCLE_FLAG: ' || DECODE (S.CYCLE#
, 0
, 'N'
, 1
, 'Y') || '
, CACHE_SIZE: ' || S.CACHE || '
, ORDER_FLAG: ' || DECODE (S.ORDER$
, 0
, 'N'
, 1
, 'Y') FROM SYS.IDNSEQ$ I
, SYS.OBJ$ O
, SYS.COL$ C
, SYS.SEQ$ S
, SYS.OBJ$ SO WHERE O.OWNER# = USERENV('SCHEMAID') AND O.OBJ# = I.OBJ# AND C.INTCOL# = I.INTCOL# AND C.OBJ# = I.OBJ# AND S.OBJ# = I.SEQOBJ# AND SO.OBJ# = I.SEQOBJ#