DBA Data[Home] [Help]

VIEW: SYS.KU$_QTAB_STORAGE_VIEW

Source

View Text - Preformatted

select  tab.obj#,tab.property,
          ts.ts#,ts.name,
          tab.pctfree$,tab.pctused$,
          tab.initrans,tab.maxtrans,
          cast( multiset(select * from ku$_column_view c
                        where c.obj_num = tab.obj#
                        order by c.col_num, c.intcol_num
                        ) as ku$_column_list_t
              )
  from tab$ tab, ts$ ts
  where tab.ts# =ts.ts#
View Text - HTML Formatted

SELECT TAB.OBJ#
, TAB.PROPERTY
, TS.TS#
, TS.NAME
, TAB.PCTFREE$
, TAB.PCTUSED$
, TAB.INITRANS
, TAB.MAXTRANS
, CAST( MULTISET(SELECT *
FROM KU$_COLUMN_VIEW C
WHERE C.OBJ_NUM = TAB.OBJ# ORDER BY C.COL_NUM
, C.INTCOL_NUM ) AS KU$_COLUMN_LIST_T )
FROM TAB$ TAB
, TS$ TS
WHERE TAB.TS# =TS.TS#