Oracle教程 2023-02-23

Oracle 视图 ALL_TYPE_METHODS 官方解释，作用，如何使用详细说明

ALL_TYPE_METHODS是Oracle系统视图，其显示的是当前用户拥有的类型的方法（METHOD）信息，具体包括该方法的名称、方法ID、返回类型和参数类型等信息。

使用ALL_TYPE_METHODS视图可以查询当前用户拥有的所有类型方法。我们可以使用ALL_TYPE_METHODS视图来查询特定的类型是否有相应的方法或了解类型中定义的方法的参数类型和属性类型。下面是一个简单的查询语句，用来查询指定类型type_name中定义的方法：

SELECT * FROM ALL_TYPE_METHODS WHERE type_name = ‘type_name’;

ALL_TYPE_METHODS describes the methods of the object types accessible to the current user.

Related Views

DBA_TYPE_METHODS describes the methods of all object types in the database.
USER_TYPE_METHODS describes the methods of the object types owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the type
`TYPE_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the type
`METHOD_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the method
`METHOD_NO`	`NUMBER`	`NOT NULL`	Method number for distinguishing overloaded methods (not to be used as ID number)
`METHOD_TYPE`	`VARCHAR2(6)`		Type of the method: `MAP` `ORDER` `PUBLIC`
`PARAMETERS`	`NUMBER`	`NOT NULL`	Number of parameters to the method
`RESULTS`	`NUMBER`	`NOT NULL`	Number of results returned by the method
`FINAL`	`VARCHAR2(3)`		Indicates whether the method is final (`YES`) or not (`NO`)
`INSTANTIABLE`	`VARCHAR2(3)`		Indicates whether the method is instantiable (`YES`) or not (`NO`)
`OVERRIDING`	`VARCHAR2(3)`		Indicates whether the method is overriding a supertype method (`YES`) or not (`NO`)
`INHERITED`	`VARCHAR2(3)`		Indicates whether the method is inherited from a supertype (`YES`) or not (`NO`)