DBA Data[Home] [Help]

VIEW: SYS.KU$_INDARRAYTYPE_VIEW

Source

View Text - Preformatted

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
View Text - HTML Formatted

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