Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.oracle.misc > #1032

Re: sqlplus : How to turn off output to terminal ?

Cross-posted to 2 groups.

Show all headers | View raw

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@ra.msstate.edu
> 
> 
> This is interesting topic. I found it today. hope it is useful. sqlplus
> "%usr_name%/%pass%@%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).

Back to comp.databases.oracle.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: sqlplus : How to turn off output to terminal ? suhong.it@gmail.com - 2017-10-06 14:41 -0700
  Re: sqlplus : How to turn off output to terminal ? Suntan <nospam@example.com> - 2017-10-11 21:46 +0000
    Re: sqlplus : How to turn off output to terminal ? VAXman-  @SendSpamHere.ORG - 2017-10-11 22:33 +0000
      Re: sqlplus : How to turn off output to terminal ? Suntan <nospam@example.com> - 2017-10-28 19:44 +0000

csiph-web