Re: DBA Views

From: Ban Spam <ban-spam_at_operamail.com>
Date: Tue, 05 Nov 2002 01:54:21 GMT
Message-ID: <Xns92BCB63519E87SunnySD@68.6.19.6>

adamr1000_at_hotmail.com (Adam Rothberg) wrote in 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

Under 9i
SQL> DESC PACKAGE_NAME
displays what you've specified.
SMOP of SQL writing SQL.
(Small Matter Of Programming - SMOP) Received on Mon Nov 04 2002 - 19:54:21 CST