Unix Technical Forum

Spool in SQL*Plus without SQL statments

This is a discussion on Spool in SQL*Plus without SQL statments within the Oracle Miscellaneous forums, part of the Oracle Database category; --> On Jun 26, 3:08 pm, jreiner...@gmail.com wrote: > On Jun 23, 12:03 pm, William Robertson <williamr2...@googlemail.com> > wrote: > ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #11 (permalink)  
Old 04-08-2008, 01:06 PM
William Robertson
 
Posts: n/a
Default Re: Spool in SQL*Plus without SQL statments

On Jun 26, 3:08 pm, jreiner...@gmail.com wrote:
> On Jun 23, 12:03 pm, William Robertson <williamr2...@googlemail.com>
> wrote:
>
>
>
> > On Jun 22, 7:53 pm, jreiner...@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/c...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.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:28 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com