Join user_procedures and user_objects : user_procedures « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. user_procedures

SQL>
SQL>
SQL> SELECT   AUTHID
  2         , p.object_name program_name
  3         , procedure_name subprogram_name
  4      FROM user_procedures p, user_objects o
  5     WHERE p.object_name = o.object_name
  6       AND p.object_name LIKE '&1'
  7  ORDER BY AUTHID, procedure_name;
Enter value for 1:
old   6:      AND p.object_name LIKE '&1'
new   6:      AND p.object_name LIKE ''

no rows selected