VIEW: SYS.KU$_OPBINDING_VIEW

Source

View Text - Preformatted

select ob.obj#, ob.bind#, ob.functionname, ob.returnschema,
         ob.returntype, ob.impschema, ob.imptype, ob.property,
         ob.spare1, ob.spare2, ob.spare3,
         cast(multiset(select * from sys.oparg$ oa
                       where oa.obj#=ob.obj# and oa.bind#=ob.bind#
                       order by oa.position
                      ) as ku$_oparg_list_t
             ),
         cast(multiset(select value(a) from sys.ku$_opancillary_view a
                       where ob.obj#=a.obj_num and ob.bind#=a.bind_num
                      ) as ku$_opancillary_list_t
             )
  from sys.opbinding$ ob

View Text - HTML Formatted

SELECT OB.OBJ#
, OB.BIND#
, OB.FUNCTIONNAME
, OB.RETURNSCHEMA
, OB.RETURNTYPE
, OB.IMPSCHEMA
, OB.IMPTYPE
, OB.PROPERTY
, OB.SPARE1
, OB.SPARE2
, OB.SPARE3
, CAST(MULTISET(SELECT *
FROM SYS.OPARG$ OA
WHERE OA.OBJ#=OB.OBJ#
AND OA.BIND#=OB.BIND# ORDER BY OA.POSITION ) AS KU$_OPARG_LIST_T )
, CAST(MULTISET(SELECT VALUE(A)
FROM SYS.KU$_OPANCILLARY_VIEW A
WHERE OB.OBJ#=A.OBJ_NUM
AND OB.BIND#=A.BIND_NUM ) AS KU$_OPANCILLARY_LIST_T )
FROM SYS.OPBINDING$ OB