Views for Packages and Procedures

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 Received on Thu Jun 12 2003 - 09:01:41 CDT