Re: how to list installed packages

hi,

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

sqlplus> descr dba_source

 Name                            Null?    Type
 ------------------------------- -------- ----
 OWNER                           NOT NULL VARCHAR2(30)
 NAME                            NOT NULL VARCHAR2(30)
 TYPE                                     VARCHAR2(12)
 LINE                            NOT NULL NUMBER
 TEXT                                     VARCHAR2(2000)

sqlplus> select distinct name from dba_source where type = 'PACKAGE';

-- 
Andreas Necker

ISB AG              Tel: +49 (0)721/82800-0
Karlstrasse 52-54   Fax: +49 (0)721/82800-82
76133 Karlsruhe     mailto:Andreas.Necker_at_isb-ag.de
Germany             http://www.isb-ag.de