Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Spool in SQL*Plus without SQL statments

Re: Spool in SQL*Plus without SQL statments

From: William Robertson <williamr2019_at_googlemail.com>
Date: Tue, 26 Jun 2007 15:34:40 -0700
Message-ID: <1182897280.416369.287400@o61g2000hsh.googlegroups.com>


On Jun 26, 3:08 pm, jreiner..._at_gmail.com wrote:
> On Jun 23, 12:03 pm, William Robertson <williamr2..._at_googlemail.com>
> wrote:
>
>
>
> > On Jun 22, 7:53 pm, jreiner..._at_gmail.com wrote:
>
> > > I thought set echo off accomplished this but now I'm just completely
> > > lost and fustrated (I don't even know what it does in SQP*Plus
> > > anymore..setting it on and off does nothing anymore).
> > > every search attempt I've made has been futile (which rarely
> > > happens...)
>
> > I'm puzzled. Wasn't this clear enough?
>
> >http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14357/ch1...
>
> > SET ECHO {ON | OFF}
>
> > Controls whether or not to echo commands in a script that is executed
> > with @, @@ or START. ON displays the commands on screen. OFF
> > suppresses the display. ECHO does not affect the display of commands
> > you enter interactively or redirect to SQL*Plus from the operating
> > system.
>
> You're puzzled? It isn't too hard to understand (for most people). I
> thought turning echo 'off' worked like it does in every other command
> line language...and in practice it seemed to be working that way.
> Don't pretend that it isn't a little weird, from a programmers
> perspective at least, it applies to the '@', '@@', START commands
> only. Good specificity though, I will admit.
>
> Hopefully the point of this post, other than attempting to ridicule
> me, was to point out how the oracle documentation would have been
> helpful. For that I apologize.
>
> Oh and to get rid of the column heading underline I asked about
> earlier its:
>
> 'set underline off'
>
> oddly enough it wasn't in the setting lists I looked at (Looked on the
> web; not oracle docs though).

You said you were confused and frustrated and didn't know what SET ECHO OFF did. The documentation seemed to me to make it pretty clear. I assumed, perhaps wrongly, that anyone working professionally with Oracle would have their most commonly accessed online manuals set up in a Firefox bookmark tab named RTFM and synchronised via Foxmarks or similar. If that is not the case then I apologise. Received on Tue Jun 26 2007 - 17:34:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US