Re: Sqlplus

From: paul cluiss <paul_cluiss_at_intervoice.com>
Date: 1999/09/21
Message-ID: <C9EAEE9426E431B5.DDA5ECD212DD7EE8.D291624B9A18A9A9_at_lp.airnews.net>#1/1


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 - 00:00:00 CEST

Original text of this message