VIEW: SYS.KU$_CLST_VIEW

Source

View Text - Preformatted

select k.clstobj#, k.clstfunc, k.flags,
         cast(multiset(select c.* from ku$_clstcol_view c
              where c.obj_num=k.clstobj#
              order by c.position
                       ) as ku$_clstcol_list_t
             ),
         cast(multiset(select * from ku$_clstjoin_view j
               where j.obj_num = k.clstobj#
                        ) as ku$_clstjoin_list_t
             ),
         (select value(z) from ku$_clst_zonemap_view z
          where z.obj_num=k.clstobj#)
  from clst$ k

View Text - HTML Formatted

SELECT K.CLSTOBJ#
, K.CLSTFUNC
, K.FLAGS
, CAST(MULTISET(SELECT C.*
FROM KU$_CLSTCOL_VIEW C
WHERE C.OBJ_NUM=K.CLSTOBJ# ORDER BY C.POSITION ) AS KU$_CLSTCOL_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_CLSTJOIN_VIEW J
WHERE J.OBJ_NUM = K.CLSTOBJ# ) AS KU$_CLSTJOIN_LIST_T )
, (SELECT VALUE(Z)
FROM KU$_CLST_ZONEMAP_VIEW Z
WHERE Z.OBJ_NUM=K.CLSTOBJ#)
FROM CLST$ K