Re: how to list installed packages

On Thu, 19 Apr 2001 10:19:38 +0200, "Wolfgang Scholz" <w.scholz_at_bull.at> wrote:

>Hello,
>
>I'm looking for the command to get the list of all installed Oracle 7.3.4
>packages for an instance.
>
>Could anyone send it to me?
>
>Thanks for help
>Wolfgang
>
>

For once

select owner, object_name
from dba_objects
where object_type = 'PACKAGE'

Hth,

Sybrand Bakker, Oracle DBA Received on Thu Apr 19 2001 - 10:01:13 CDT