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#
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#
|
|
|