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
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