VIEW: SYS.KU$_TAB_TSUBPART_VIEW

Source

View Text - Preformatted

select  dsp.bo#, dsp.spart_position, dsp.spart_name,
          (select( ts.name) from sys.ts$ ts where ts.ts# = dsp.ts#),
          dsp.ts#, dsp.flags, dsp.hiboundlen,
          sys.dbms_metadata_util.long2varchar( dsp.hiboundlen,
                                              'SYS.DEFSUBPART$',
                                              'HIBOUNDVAL',
                                              dsp.rowid),
          cast(multiset(select * from ku$_tlob_comppart_view tlcv
                        where  tlcv.base_objnum = dsp.bo#
                           and tlcv.spart_pos = dsp.spart_position
                        order by tlcv.intcol_num
                      ) as ku$_tlob_comppart_list_t),
          bhiboundval
  from    sys.defsubpart$ dsp

View Text - HTML Formatted

SELECT DSP.BO#
, DSP.SPART_POSITION
, DSP.SPART_NAME
, (SELECT( TS.NAME)
FROM SYS.TS$ TS
WHERE TS.TS# = DSP.TS#)
, DSP.TS#
, DSP.FLAGS
, DSP.HIBOUNDLEN
, SYS.DBMS_METADATA_UTIL.LONG2VARCHAR( DSP.HIBOUNDLEN
, 'SYS.DEFSUBPART$'
, 'HIBOUNDVAL'
, DSP.ROWID)
, CAST(MULTISET(SELECT *
FROM KU$_TLOB_COMPPART_VIEW TLCV
WHERE TLCV.BASE_OBJNUM = DSP.BO#
AND TLCV.SPART_POS = DSP.SPART_POSITION ORDER BY TLCV.INTCOL_NUM ) AS KU$_TLOB_COMPPART_LIST_T)
, BHIBOUNDVAL
FROM SYS.DEFSUBPART$ DSP