Oracle PL/SQL/System Tables Views/dba method result

Query dba_method_result

   <source lang="sql">

SQL> SQL> clear breaks breaks cleared SQL> break on num skip 1 SQL> SQL> column method_name format a20 SQL> column param_name format a20 SQL> column result_type_name a25 SP2-0158: unknown COLUMN option "a25" SQL> column num format 999 SQL> SQL> select tm.method_no num,

 2             tm.method_name,
 3             tm.method_type,
 4             tm.final,
 5             tm.instantiable,
 6             tm.overriding,
 7             tm.inherited,
 8             mr.result_type_name
 9        from dba_type_methods tm,
10            dba_method_results mr
11      where tm.owner = mr.owner
12        and tm.type_name = mr.type_name
13        and tm.method_name = mr.method_name
14        and tm.method_no = mr.method_no
15        and tm.owner = "OE"
16        and tm.type_name = "COMPOSITE_CATEGORY_TYP"
17      order by 1, 2, 3
18     /

no rows selected SQL> --

</source>