Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL to list a user's packages and its procedures
I know I can do in sqlplus
SQL> DESC PKG I know I can
SQL> select object_name from user_objects where object_type='PACKAGE_BODY';
I know I can
SQL> select name, text from user_source where name like 'XX%'
None of these gives me a clean way to return (from a select) the package name and its procedures.
What object do I need to query to get back a result such as:
PACKAGE_NAME TYPE PROC_OR_FUNCTION ------------ ---- ---------------- PKG1 FUNCTION FNC1 PKG1 FUNCTION FNC2 PKG1 FUNCTION FNC3 PKG1 PROCEDURE PROC1
?
-- jeremyReceived on Fri Dec 08 2006 - 05:36:34 CST
============================================================
ENVIRONMENT: Oracle 9iR2 / Oracle HTTP Server / mod_plsql / Solaris 8
============================================================