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