DBA_TYPE_METHODS

2025-11-14 07:33:33  Updated

Note

OceanBase Database does not support this view at present.

Purpose

The DBA_TYPE_METHODS view displays the methods of all object types in the database.

  • ALL_TYPE_METHODS

  • USER_TYPE_METHODS

Columns

Column Type Nullable? Description
OWNER VARCHAR2(30) NO The owner of the type.
TYPE_NAME VARCHAR2(30) NO The name of the type.
METHOD_NAME VARCHAR2(30) NO The name of the method.
METHOD_NO NUMBER NO The method number, which is used to distinguish between overloaded methods.
METHOD_TYPE VARCHAR2(6) NO The type of the method. Valid values:
  • MAP
  • ORDER
  • PUBLIC
  • PARAMETERS NUMBER NO The number of method parameters.
    RESULTS NUMBER NO The number of results returned by the method.
    FINAL VARCHAR2(3) NO Indicates whether the method is final. Valid values:
  • YES
  • NO
  • INSTANTIABLE VARCHAR2(3) NO Indicates whether the method is instantiable. Valid values:
  • YES
  • NO
  • OVERRIDING VARCHAR2(3) NO Indicates whether the method is overriding a supertype method. Valid values:
  • YES
  • NO
  • INHERITED VARCHAR2(3) NO Indicates whether the method is inherited from a supertype. Valid values:
  • YES
  • NO
  • Contact Us