Re: DBA Views

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 5 Nov 2002 06:12:27 -0800
Message-ID: <2687bb95.0211050612.5c872568@posting.google.com>

adamr1000_at_hotmail.com (Adam Rothberg) wrote in message news:<68326679.0211041547.70bd9118_at_posting.google.com>...
> Does anyone know a query I can run against the DBA_xxx views to obtain
> all packages' names within a schema and the names of the functions and
> procedures defined within each package? Similar to the way you can
> join DBA_TABLES and DBA_TAB_COLUMNS to get a list of all tables and
> the columns in those tables
>
> Thanks.
>
> -Adam

1 - The describe command will show the procedures with parameters 2 - ALL_, DBA_, USER_ARGUMENTS is provided by Oracle

HTH -- Mark D Powell -- Received on Tue Nov 05 2002 - 08:12:27 CST