Re: View for procedure names

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Fri, 09 Jul 1999 14:26:21 -0700
Message-ID: <378668FD.123BC624@us.oracle.com>

SELECT owner, name
FROM dba_source
WHERE type = 'PROCEDURE';

Add OR type = 'FUNCTION' if you want them too.

You need to be granted access to the DBA views for this to work. Or just log in as you do in OEM since you have access to a privileged account for that.

HTH. Pete

arivlin_at_my-deja.com wrote:

> I am looking for a view that will list all procedures and their owners.
> there must be one in Oracle, because Oracle Enterprise Manager is able
> to list procedures. What is the view and what kind of permissions do I
> need to access it?
>
> Alex
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

--
Regards

Pete

Received on Fri Jul 09 1999 - 16:26:21 CDT