Query dba_type_method table : dba_type_method « System Tables Views « Oracle PL / SQL






Query dba_type_method table

 
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 num format 999
SQL>  column "IN/OUT" format a6
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             mp.param_name,
  9             mp.param_mode "IN/OUT"
 10       from dba_type_methods tm,
 11            dba_method_params mp
 12      where tm.owner = mp.owner
 13        and tm.type_name = mp.type_name
 14        and tm.method_name = mp.method_name
 15        and tm.method_no = mp.method_no
 16        and tm.owner = 'OE'
 17        and tm.type_name = 'COMPOSITE_CATEGORY_TYP'
 18      order by 1, 2, 3
 19     /

no rows selected

SQL> --

 








Related examples in the same category