VIEW: SYS.KU$_COLLECTION_VIEW

Source

View Text - Preformatted

select
  toid,                                                              /* TOID */
  version#,                                  /* internal type version number */
  coll_toid,                        /* collection TOID (TABLE, VARRAY, etc.) */
  coll_version#,                /* collection type's internal version number */
  elem_toid,                                               /* element's TOID */
  elem_version#,                 /* element's type's internal version number */
  synobj#,                                           /* obj# of type synonym */
  properties,                                       /* element's properties: */
  charsetid,                                             /* character set id */
  charsetform,                                         /* character set form */
  length,                                /* fixed character string length or */
                                  /* maximum varying character string length */
  precision,                  /* fixed- or floating-point numeric precision */
  scale,                                        /* fixed-point numeric scale */
  upper_bound,              /* fixed array size or varying array upper bound */
  spare1,                                    /* fractional seconds precision */
  spare2,                                /* interval leading field precision */
  spare3,
  (select value(st) from ku$_simple_type_View st
                where st.toid = c.coll_toid and
                      st.version = (SELECT MAX(ST2.VERSION) FROM ku$_simple_type_View st2
                                    WHERE ST2.TOID = c.coll_toid)),
  (select value(st) from ku$_simple_type_View st
                where st.toid = c.elem_toid and
                      st.version = (SELECT MAX(ST2.VERSION) FROM ku$_simple_type_View st2
                                    WHERE ST2.TOID = c.elem_toid))
  FROM sys.collection$ c

View Text - HTML Formatted

SELECT TOID
, /* TOID */ VERSION#
, /* INTERNAL TYPE VERSION NUMBER */ COLL_TOID
, /* COLLECTION TOID (TABLE
, VARRAY
, ETC.) */ COLL_VERSION#
, /* COLLECTION TYPE'S INTERNAL VERSION NUMBER */ ELEM_TOID
, /* ELEMENT'S TOID */ ELEM_VERSION#
, /* ELEMENT'S TYPE'S INTERNAL VERSION NUMBER */ SYNOBJ#
, /* OBJ# OF TYPE SYNONYM */ PROPERTIES
, /* ELEMENT'S PROPERTIES: */ CHARSETID
, /* CHARACTER SET ID */ CHARSETFORM
, /* CHARACTER SET FORM */ LENGTH
, /* FIXED CHARACTER STRING LENGTH OR */ /* MAXIMUM VARYING CHARACTER STRING LENGTH */ PRECISION
, /* FIXED- OR FLOATING-POINT NUMERIC PRECISION */ SCALE
, /* FIXED-POINT NUMERIC SCALE */ UPPER_BOUND
, /* FIXED ARRAY SIZE OR VARYING ARRAY UPPER BOUND */ SPARE1
, /* FRACTIONAL SECONDS PRECISION */ SPARE2
, /* INTERVAL LEADING FIELD PRECISION */ SPARE3
, (SELECT VALUE(ST)
FROM KU$_SIMPLE_TYPE_VIEW ST
WHERE ST.TOID = C.COLL_TOID AND ST.VERSION = (SELECT MAX(ST2.VERSION)
FROM KU$_SIMPLE_TYPE_VIEW ST2
WHERE ST2.TOID = C.COLL_TOID))
, (SELECT VALUE(ST)
FROM KU$_SIMPLE_TYPE_VIEW ST
WHERE ST.TOID = C.ELEM_TOID AND ST.VERSION = (SELECT MAX(ST2.VERSION)
FROM KU$_SIMPLE_TYPE_VIEW ST2
WHERE ST2.TOID = C.ELEM_TOID))
FROM SYS.COLLECTION$ C