Re: SQL to list a user's packages and its procedures

On Dec 8, 12:36 pm, Jeremy <jeremy0..._at_gmail.com> wrote:
> 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
> ============================================================

select distinct package_name, object_name from user_arguments

-- 
Sybrand Bakker
Senior Oracle DBA