Home Oracle Commands Oracle Data Dictionary
v$ Performance views

ALL_TYPES

Description of types accessible to the user

Columns
   ___________________________
 
   OWNER
      Owner of the type
   TYPE_NAME
      Name of the type
   TYPE_OID
      Object identifier (OID) of the type
   TYPECODE
      Typecode of the type
   ATTRIBUTES
      Number of attributes in the type
   METHODS
      Number of methods in the type
   PREDEFINED
      Is the type a predefined type?
   INCOMPLETE
      Is the type an incomplete type?
   FINAL
      Is the type a final type?
   INSTANTIABLE
      Is the type an instantiable type?
   SUPERTYPE_OWNER
      Owner of the supertype (null if type is not a subtype)
   SUPERTYPE_NAME
      Name of the supertype (null if type is not a subtype)
   LOCAL_ATTRIBUTES
      Number of local (not inherited) attributes (if any) in the subtype
   LOCAL_METHODS
      Number of local (not inherited) methods (if any) in the subtype
   TYPEID
      Type id value of the type

Related:



Simon Sheppard
SS64.com