VIEW: SYS.KU$_INDEXTYPE_VIEW

Source

View Text - Preformatted

select '1','1',
         it.obj#, value(o),
         (select value(oit) from sys.ku$_schemaobj_view oit
          where it.implobj#=oit.obj_num),
         it.property,
          cast(multiset(select value(io) from sys.ku$_indexop_view io
                        where it.obj#=io.obj_num
                        /* the following order-by clause exists solely
                           to assure repeatable regression tests results */
                        order by io.oper_obj.owner_name, io.oper_obj.name
                       ) as ku$_indexop_list_t
              ),
          cast(multiset(select value(ia) from sys.ku$_indarraytype_view ia
                        where it.obj#=ia.obj_num
                       ) as ku$_indarraytype_list_t
              )
  from  sys.ku$_schemaobj_view o, sys.indtypes$ it
  where it.obj#=o.obj_num
        AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0) OR
              EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '1'
, IT.OBJ#
, VALUE(O)
, (SELECT VALUE(OIT)
FROM SYS.KU$_SCHEMAOBJ_VIEW OIT
WHERE IT.IMPLOBJ#=OIT.OBJ_NUM)
, IT.PROPERTY
, CAST(MULTISET(SELECT VALUE(IO)
FROM SYS.KU$_INDEXOP_VIEW IO
WHERE IT.OBJ#=IO.OBJ_NUM /* THE FOLLOWING ORDER-BY CLAUSE EXISTS SOLELY TO ASSURE REPEATABLE REGRESSION TESTS RESULTS */ ORDER BY IO.OPER_OBJ.OWNER_NAME
, IO.OPER_OBJ.NAME ) AS KU$_INDEXOP_LIST_T )
, CAST(MULTISET(SELECT VALUE(IA)
FROM SYS.KU$_INDARRAYTYPE_VIEW IA
WHERE IT.OBJ#=IA.OBJ_NUM ) AS KU$_INDARRAYTYPE_LIST_T )
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.INDTYPES$ IT
WHERE IT.OBJ#=O.OBJ_NUM
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))