Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Join user_procedures and user_objects

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