VIEW: SYS.TP$

Source

View Text - Preformatted

select tp.obj#, tp.bo#, c.intcol#, c.type#,
      decode(bitand(c.property, 1), 1, a.name, c.name) cname, tp.rowcnt
      from sys.col$ c, sys.tabpart$ tp, attrcol$ a
      where tp.bo# = c.obj# and
      c.obj# = a.obj#(+) and c.intcol# = a.intcol#(+) and
      bitand(c.property,32768) != 32768    /* not unused columns */
union
select tcp.obj#, tcp.bo#, c.intcol#, c.type#,
      decode(bitand(c.property, 1), 1, a.name, c.name) cname, tcp.rowcnt
      from sys.col$ c, sys.tabcompart$ tcp, attrcol$ a
      where tcp.bo# = c.obj# and
      c.obj# = a.obj#(+) and c.intcol# = a.intcol#(+) and
      bitand(c.property,32768) != 32768    /* not unused columns */

View Text - HTML Formatted

SELECT TP.OBJ#
, TP.BO#
, C.INTCOL#
, C.TYPE#
, DECODE(BITAND(C.PROPERTY
, 1)
, 1
, A.NAME
, C.NAME) CNAME
, TP.ROWCNT
FROM SYS.COL$ C
, SYS.TABPART$ TP
, ATTRCOL$ A
WHERE TP.BO# = C.OBJ# AND C.OBJ# = A.OBJ#(+)
AND C.INTCOL# = A.INTCOL#(+) AND BITAND(C.PROPERTY
, 32768) != 32768 /* NOT UNUSED COLUMNS */ UNION SELECT TCP.OBJ#
, TCP.BO#
, C.INTCOL#
, C.TYPE#
, DECODE(BITAND(C.PROPERTY
, 1)
, 1
, A.NAME
, C.NAME) CNAME
, TCP.ROWCNT
FROM SYS.COL$ C
, SYS.TABCOMPART$ TCP
, ATTRCOL$ A
WHERE TCP.BO# = C.OBJ# AND C.OBJ# = A.OBJ#(+)
AND C.INTCOL# = A.INTCOL#(+) AND BITAND(C.PROPERTY
, 32768) != 32768 /* NOT UNUSED COLUMNS */