Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBA Views
Hi , proceed in the following way
select Object_name from user_objects where upper(object_type)='PACKAGE';
sai
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
Received on Tue Nov 05 2002 - 11:13:05 CST