Re: Sqlplus

From: paul cluiss <paul_cluiss_at_intervoice.com>
Date: Tue, 21 Sep 1999 08:56:10 -0500
Message-ID: <C9EAEE9426E431B5.DDA5ECD212DD7EE8.D291624B9A18A9A9@lp.airnews.net>

Why don't you use something like this:

SET PAGESIZE 66
COLUMN object_type FORMAT A20
COLUMN object_name FORMAT A30
COLUMN status FORMAT A10
BREAK ON object_type SKIP 1
SPOOL psobj.lis
SELECT object_type, object_name, status FROM user_objects
WHERE object_type IN ('PACKAGE', 'PACKAGE BODY', 'FUNCTION', 'PROCEDURE') ORDER BY object_type, status, object_name /
SPOOL OFF Then check the file psobj.lis

groGnon wrote:

> hi
> i would like to know, in sqlplus, oracle 8, how to know what objects are
> active
> thanks
Received on Tue Sep 21 1999 - 08:56:10 CDT