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

Query dba_method_result

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