Re: Views for Packages and Procedures

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 13 Jun 2003 10:54:43 -0700
Message-ID: <92eeeff0.0306130954.bf1f05a@posting.google.com>

fishburn_at_sybase.com (David) wrote in message news:<3a28ef03.0306130538.1d33a93f_at_posting.google.com>...
> 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

USER_OBJECTS, ALL_OBJECTS. Look at object_type in both.

Regards
/Rauf Sarwar Received on Fri Jun 13 2003 - 12:54:43 CDT