VIEW: SYS.KU$_TLOB_COMPPART_VIEW

Source

View Text - Preformatted

select  dspl.bo#, '"'||c.name||'"', dspl.intcol#,
             dspl.spart_position, dspl.flags, dspl.lob_spart_name,
             (select(t.name) from sys.ts$ t where t.ts# = dspl.lob_spart_ts#),
             dspl.lob_spart_ts#
     from    sys.col$ c, sys.defsubpartlob$ dspl
     where   dspl.bo# = c.obj#
         and dspl.intcol# = c.col#

View Text - HTML Formatted

SELECT DSPL.BO#
, '"'||C.NAME||'"'
, DSPL.INTCOL#
, DSPL.SPART_POSITION
, DSPL.FLAGS
, DSPL.LOB_SPART_NAME
, (SELECT(T.NAME)
FROM SYS.TS$ T
WHERE T.TS# = DSPL.LOB_SPART_TS#)
, DSPL.LOB_SPART_TS#
FROM SYS.COL$ C
, SYS.DEFSUBPARTLOB$ DSPL
WHERE DSPL.BO# = C.OBJ#
AND DSPL.INTCOL# = C.COL#