Re: sqlplus : How to turn off output to terminal ?
From: Suntan <nospam_at_example.com>
Date: Wed, 11 Oct 2017 21:46:00 -0000 (UTC)
Message-ID: <pan.2017.10.11.21.45.59_at_example.com>
>> How do I turn off output to terminal sqlplus from a select statement
>> when I am spooling the result to a text file ?
>>
>> I have tried echo off, feedback off etc. but nothing seems to work. The
>> problem is not easy to handle when the result is huge and I am over a
>> modem connection.
>>
>> Thanks.
>>
>> Atif Khan
>> aak2_at_ra.msstate.edu
Date: Wed, 11 Oct 2017 21:46:00 -0000 (UTC)
Message-ID: <pan.2017.10.11.21.45.59_at_example.com>
[Quoted] On Fri, 06 Oct 2017 14:41:42 -0700, suhong.it wrote:
> On Friday, February 28, 1997 at 3:00:00 AM UTC-5, Atif Ahmad Khan wrote:
>> How do I turn off output to terminal sqlplus from a select statement
>> when I am spooling the result to a text file ?
>>
>> I have tried echo off, feedback off etc. but nothing seems to work. The
>> problem is not easy to handle when the result is huge and I am over a
>> modem connection.
>>
>> Thanks.
>>
>> Atif Khan
>> aak2_at_ra.msstate.edu
> > > This is interesting topic. I found it today. hope it is useful. sqlplus > "%usr_name%/%pass%_at_%db" @sqlscript.sql > suppressed.out
As Suhong said, run it as a batch command with redirected output. If you need to, you can check on progress by connecting periodically and doing "tail -f suppressed.out". If you don't know if a result will be huge, connect via a utility or system that can junk terminal output yet still allow a "spool wanted.out". In an academic environment you may have VMS. Connect through VMS and type Ctrl-O (a second one resumes o/p). Received on Wed Oct 11 2017 - 23:46:00 CEST