Re: Views for Packages and Procedures

<bsc7080mqc_at_mylxhq.com> wrote in message news:DOtGa.6638$eU4.3517_at_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
>

dont think so as this wont give you just the names of the packages which is what the OP wanted Received on Fri Jun 13 2003 - 19:34:00 CDT