DBA_TYPE_METHODS
Description of methods of all types in the database
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OWNER | VARCHAR2 | (30) | Yes | Owner of the type |
| TYPE_NAME | VARCHAR2 | (30) | Yes | Name of the type |
| METHOD_NAME | VARCHAR2 | (30) | Yes | Name of the method |
| METHOD_NO | NUMBER | Yes | Method number for distinguishing overloaded method (not to be used as ID number) | |
| METHOD_TYPE | VARCHAR2 | (6) | Type of the method | |
| PARAMETERS | NUMBER | Yes | Number of parameters to the method | |
| RESULTS | NUMBER | Yes | Number of results returned by the method | |
| FINAL | VARCHAR2 | (3) | Is the method final ? | |
| INSTANTIABLE | VARCHAR2 | (3) | Is the method instantiable ? | |
| OVERRIDING | VARCHAR2 | (3) | Is the method overriding a supertype method ? | |
| INHERITED | VARCHAR2 | (3) | Is the method inherited from the supertype ? |
Usage:
cursor cur_method(c_name in dba_types.type_name%type
, c_owner in dba_types.owner%type) is
SELECT OWNER
, TYPE_NAME
, METHOD_NAME
, METHOD_NO
, METHOD_TYPE
, PARAMETERS
, RESULTS
FROM SYS.DBA_TYPE_METHODS
where owner = c_owner
and type_name = c_name
order by method_no;