ALL_TYPE_METHODS

Previous Next JavaScript must be enabled to correctly display this content

3.129 ALL_TYPE_METHODS

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`)

See Also:

"DBA_TYPE_METHODS"
"USER_TYPE_METHODS"