VIEW: SYS.TSP$

Source

View Text - Preformatted

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

View Text - HTML Formatted

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