Re: Spool in SQL*Plus without SQL statments
- From: William Robertson <williamr2019@xxxxxxxxxxxxxx>
- Date: Tue, 26 Jun 2007 15:34:40 -0700
On Jun 26, 3:08 pm, jreiner...@xxxxxxxxx wrote:
On Jun 23, 12:03 pm, William Robertson <williamr2...@xxxxxxxxxxxxxx>
wrote:
On Jun 22, 7:53 pm, jreiner...@xxxxxxxxx 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.
.
- References:
- Spool in SQL*Plus without SQL statments
- From: jreinert13
- Re: Spool in SQL*Plus without SQL statments
- From: William Robertson
- Re: Spool in SQL*Plus without SQL statments
- From: jreinert13
- Spool in SQL*Plus without SQL statments
- Prev by Date: Re: oracle 10g cryptography problem
- Next by Date: Re: oracle 10g cryptography problem
- Previous by thread: Re: Spool in SQL*Plus without SQL statments
- Next by thread: RSA decryption in Oracle 9i
- Index(es):
Relevant Pages
|
