VIEW: SYS.KU$_IDENTITY_COL_VIEW

Source

View Text - Preformatted

select '1','1',
         obj#,
         (select name from col$ c where c.obj#=s.obj# and c.intcol#=s.intcol#),
         (select trunc(c.property / power(2,32))
          from col$ c where c.obj#=s.obj# and c.intcol#=s.intcol#),
         intcol#,
         seqobj#,
         startwith,
         (select value(sv) from ku$_idcol_seq_view sv where obj_num=s.seqobj#)
  from idnseq$ s

View Text - HTML Formatted

SELECT '1'
, '1'
, OBJ#
, (SELECT NAME
FROM COL$ C
WHERE C.OBJ#=S.OBJ#
AND C.INTCOL#=S.INTCOL#)
, (SELECT TRUNC(C.PROPERTY / POWER(2
, 32))
FROM COL$ C
WHERE C.OBJ#=S.OBJ#
AND C.INTCOL#=S.INTCOL#)
, INTCOL#
, SEQOBJ#
, STARTWITH
, (SELECT VALUE(SV)
FROM KU$_IDCOL_SEQ_VIEW SV
WHERE OBJ_NUM=S.SEQOBJ#)
FROM IDNSEQ$ S