Re: find packages

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Thu, 08 Jul 1999 13:20:13 GMT
Message-ID: <3784a2d6.2311263@inet16.us.oracle.com>

On 8 Jul 1999 08:49:37 GMT, abate_at_students.cs.unibo.it (Pietro Abate) wrote:

>Hi,
> How I could find all the packages installed in my dbms ?

select owner, object_name
  from all_objects
 where object_type = 'PACKAGE';

> Which are the standard locations of the source of packages
> ships with Oracle8i ?

$ORACLE_HOME/rdbms/admin

> i.e. Is Intermadia or ConText packages include with Oracle8i
> Enterprise edition ?
>
> TIA,
> pietro

chris.

--
Christopher Beck
Oracle Corporation
clbeck_at_us.oracle.com
Reston, VA.

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jul 08 1999 - 08:20:13 CDT