Re: Views for Packages and Procedures

On 13 Jun 2003 06:38:24 -0700, fishburn_at_sybase.com (David) 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

all_source
all_arguments
all_objects where object_type in ('PROCEDURE','FUNCTION','PACKAGE')

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Jun 13 2003 - 11:39:40 CDT