Re: Views for Packages and Procedures

True enough... you would need to look at the table and define the columns you want, but also do a distinct as well. It will work though.

On Sat, 14 Jun 2003 01:34:00 +0100, "DJ" <nospamplease_at_goaway.com> wrote:

>
><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
>

MylxHQ - Oracle Resource Portal
http://oracle.mylxhq.com Received on Sat Jun 14 2003 - 00:58:43 CDT