Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> 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
![]() |
![]() |