Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: how to list installed packages

Re: how to list installed packages

From: Andreas Necker <Andreas.Necker_at_isb-ag.de>
Date: Thu, 19 Apr 2001 13:14:11 +0200
Message-ID: <3ADEC883.7F3BB79B@isb-ag.de>

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
Received on Thu Apr 19 2001 - 06:14:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US