Re: packages installed

From: William Bailey <billbailey64_at_netzero.net>
Date: Thu, 08 Mar 2001 01:47:11 GMT
Message-ID: <zwBp6.3319$68.724413@typhoon.tampabay.rr.com>

select object_type, owner, object_name, status from dba_objects
where object_type in ('PACKAGE', 'PACKAGE BODY');

Same query can be applied for PROCEDURE, FUNCTION, TRIGGER, etc.

I assume you meant PL/SQL packages .. if not, can you be more specific?

"Simon Cunningham" <cs40_at_gre.ac.uk> wrote in message news:3AA63D9F.24E3FE58_at_gre.ac.uk...
> Is there a view in the data dict that tells you all the packages
> installed???
>
>
Received on Wed Mar 07 2001 - 19:47:11 CST