DBA Data[Home] [Help]

VIEW: SYS.KU$_SIMPLE_TYPE_VIEW

Source

View Text - Preformatted

select
   toid,
   version#,
   version,
   typecode,
   properties,
   attributes,
   local_attrs,
   methods,
   hiddenMethods,
   typeid,
   roottoid,
   hashcode,
  (select value(so) from ku$_edition_schemaobj_view so
    where so.oid = toid and so.type_num = 13),
  (select name from obj$ o where o.oid$ = toid and o.type#=13)
  from type$ t
View Text - HTML Formatted

SELECT TOID
, VERSION#
, VERSION
, TYPECODE
, PROPERTIES
, ATTRIBUTES
, LOCAL_ATTRS
, METHODS
, HIDDENMETHODS
, TYPEID
, ROOTTOID
, HASHCODE
, (SELECT VALUE(SO)
FROM KU$_EDITION_SCHEMAOBJ_VIEW SO
WHERE SO.OID = TOID
AND SO.TYPE_NUM = 13)
, (SELECT NAME
FROM OBJ$ O
WHERE O.OID$ = TOID
AND O.TYPE#=13)
FROM TYPE$ T