select
a.toid,
a.version#,
a.name,
a.attribute#,
a.attr_version#,
a.attr_toid,
a.synobj#,
a.properties,
a.charsetid,
a.charsetform,
a.length,
a.precision#,
a.scale,
a.externname,
a.xflags,
a.spare1,
a.spare2,
a.spare3,
a.spare4,
a.spare5,
a.setter,
a.getter,
(select value(st) from ku$_simple_type_view st
where a.attr_toid = st.toid
and st.version = (SELECT MAX(ST2.VERSION)
FROM ku$_simple_type_View st2
WHERE ST2.TOID = a.attr_toid))
from sys.attribute$ a
SELECT
A.TOID
,
A.VERSION#
,
A.NAME
,
A.ATTRIBUTE#
,
A.ATTR_VERSION#
,
A.ATTR_TOID
,
A.SYNOBJ#
,
A.PROPERTIES
,
A.CHARSETID
,
A.CHARSETFORM
,
A.LENGTH
,
A.PRECISION#
,
A.SCALE
,
A.EXTERNNAME
,
A.XFLAGS
,
A.SPARE1
,
A.SPARE2
,
A.SPARE3
,
A.SPARE4
,
A.SPARE5
,
A.SETTER
,
A.GETTER
,
(SELECT VALUE(ST)
FROM KU$_SIMPLE_TYPE_VIEW ST
WHERE A.ATTR_TOID = ST.TOID
AND ST.VERSION = (SELECT MAX(ST2.VERSION)
FROM KU$_SIMPLE_TYPE_VIEW ST2
WHERE ST2.TOID = A.ATTR_TOID))
FROM SYS.ATTRIBUTE$ A
|
|
|