VIEW: SYS.KU$_LOB_VIEW

Source

View Text - Preformatted

select l.obj#, l.col#, l.intcol#,
        (select value(o) from ku$_schemaobj_view o
         where o.obj_num = l.lobj#),
        (select value(s) from ku$_storage_view s
         where s.file_num  = l.file#
         and   s.block_num = l.block#
         and   s.ts_num    = l.ts#),
         (select value(s) from ku$_deferred_stg_view s
          where s.obj_num = l.lobj#),
        (select ts.name from ts$ ts where l.ts# = ts.ts#),
        (select ts.blocksize from ts$ ts where l.ts# = ts.ts#),
        l.ind#,
        (select value(i) from ku$_lobindex_view i where i.obj_num=l.ind#),
        l.chunk, l.pctversion$, l.flags, l.property,
        l.retention, l.freepools, l.spare1, l.spare2, l.spare3
  from lob$ l

View Text - HTML Formatted

SELECT L.OBJ#
, L.COL#
, L.INTCOL#
, (SELECT VALUE(O)
FROM KU$_SCHEMAOBJ_VIEW O
WHERE O.OBJ_NUM = L.LOBJ#)
, (SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE S.FILE_NUM = L.FILE#
AND S.BLOCK_NUM = L.BLOCK#
AND S.TS_NUM = L.TS#)
, (SELECT VALUE(S)
FROM KU$_DEFERRED_STG_VIEW S
WHERE S.OBJ_NUM = L.LOBJ#)
, (SELECT TS.NAME
FROM TS$ TS
WHERE L.TS# = TS.TS#)
, (SELECT TS.BLOCKSIZE
FROM TS$ TS
WHERE L.TS# = TS.TS#)
, L.IND#
, (SELECT VALUE(I)
FROM KU$_LOBINDEX_VIEW I
WHERE I.OBJ_NUM=L.IND#)
, L.CHUNK
, L.PCTVERSION$
, L.FLAGS
, L.PROPERTY
, L.RETENTION
, L.FREEPOOLS
, L.SPARE1
, L.SPARE2
, L.SPARE3
FROM LOB$ L