select ia.obj#, ia.type,
(select value(o1) from ku$_schemaobj_view o1
where o1.obj_num=ia.basetypeobj#),
(select value(o2) from ku$_schemaobj_view o2
where o2.obj_num=ia.arraytypeobj#)
from sys.indarraytype$ ia
SELECT IA.OBJ#
, IA.TYPE
,
(SELECT VALUE(O1)
FROM KU$_SCHEMAOBJ_VIEW O1
WHERE O1.OBJ_NUM=IA.BASETYPEOBJ#)
,
(SELECT VALUE(O2)
FROM KU$_SCHEMAOBJ_VIEW O2
WHERE O2.OBJ_NUM=IA.ARRAYTYPEOBJ#)
FROM SYS.INDARRAYTYPE$ IA
|
|
|