Re: spool question

From: kyutae lim <ktlim_at_lgtel.co.kr>
Date: Thu, 01 Oct 1998 05:33:44 GMT
Message-ID: <36131452.DCC1A107@lgtel.co.kr>

hi!
I have a shortcut method for the question. first you have to make a script file.
this is a sample file
sample.sql :

---

set echo off
set feedb off
set pages 0

select * from emp
/
exit

---

second just run this script with output file redirection at UNIX shell exam)
% sqlplus -s scott/tiger @sample >! sample.log

bye~

badstreetboy_at_my-dejanews.com wrote:

> When I do a spool to copy the output to the file, the command I enter is also
> copied. eg.
> spool file_name
> select * from t1;
> ...
> ...
> ...
> spool off;
>
> the select statement is also copied to the file. How to get rid of that?
> Thanks.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Oct 01 1998 - 00:33:44 CDT