Re: Views for Packages and Procedures

From: <bsc7080mqc_at_mylxhq.com>
Date: Fri, 13 Jun 2003 20:29:02 -0400
Message-ID: <DOtGa.6638$eU4.3517@fe04.atl2.webusenet.com>

SELECT * FROM DBA_SOURCE is what you are looking for.

On 12 Jun 2003 14:01:41 GMT, David Fishburn <fishburn_spam_at_off.ianywhere.com> wrote:

>
>Oracle 9.01 WinXP
>
>
>I can do the following to get a list of all tables (given a prefix):
>select table_name, owner, tablespace_name
> from ALL_ALL_TABLES
> where table_name LIKE 'dave%'
> order by table_name
>
>Likewise for views:
>select view_name, owner
> from ALL_VIEWS
> where view_name LIKE 'dave%'
> order by view_name
>
>I am trying to do the same thing for:
>1. Packages
>2. Procedures
>
>I can't find corresponding views (like I did for tables and views), and
>didnt see any names that seemed appropriate.
>
>Does anyone have any suggestions?
>
>Thanks,
>Dave

MylxHQ - Oracle Resource Portal
http://oracle.mylxhq.com Received on Fri Jun 13 2003 - 19:29:02 CDT