Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL to list a user's packages and its procedures

SQL to list a user's packages and its procedures

From: Jeremy <jeremy0505_at_gmail.com>
Date: Fri, 8 Dec 2006 11:36:34 -0000
Message-ID: <MPG.1fe35e986a23152e98a395@news.individual.net>

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

?

-- 
jeremy


============================================================
ENVIRONMENT: Oracle 9iR2 / Oracle HTTP Server / mod_plsql / Solaris 8
============================================================
Received on Fri Dec 08 2006 - 05:36:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US