Re: DBA Views

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Tue, 05 Nov 2002 00:23:16 GMT
Message-ID: <3DC70F69.6954ED32@exesolutions.com>

Adam Rothberg wrote:

> 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

SELECT owner, object_name, package_name, argument_name, data_type, in_out FROM dba_arguments
WHERE ....
ORDER BY position;

Is a start

Daniel Morgan Received on Mon Nov 04 2002 - 18:23:16 CST