RE: How to clear sqlplus settings???

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Thu, 23 Aug 2001 15:27:35 -0700
Message-ID: <F001.003764E2.20010823152911@fatcity.com>

clear all
or
clear settings

but that is a one second SFTH

hth!

-----Original Message-----
Sent: Thursday, August 23, 2001 6:59 PM
To: Multiple recipients of list ORACLE-L

All,

How to clear sql plus settings? I have compute sum of bytes on report for one sql, and cannot get rid of it, now sqlplus computes total whenever I have a bytes column. The same thing for other settings. So what's the way to clear col, ttitle, compute, pagesize, linesize, variables, and other settings you know.

Thank you!

Andrea

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Andrea Oracle
INET: andreaoracle_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mohan, Ross
INET: MohanR_at_STARS-SMI.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------