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

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

Path	csiph.com!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Suntan <nospam@example.com>
Newsgroups	comp.databases.oracle.misc, comp.os.vms
Subject	Re: sqlplus : How to turn off output to terminal ?
Date	Wed, 11 Oct 2017 21:46:00 -0000 (UTC)
Organization	A noiseless patient Spider
Lines	26
Message-ID	<pan.2017.10.11.21.45.59@example.com> (permalink)
References	<aak2.857156253@Isis.MsState.Edu> <754ece62-b02f-42cf-8f5e-8306a929a810@googlegroups.com>
Mime-Version	1.0
Content-Type	text/plain; charset=UTF-8
Content-Transfer-Encoding	8bit
Injection-Date	Wed, 11 Oct 2017 21:46:00 -0000 (UTC)
Injection-Info	reader02.eternal-september.org; posting-host="c2f8f83af40ce1ffe0a18fb8e59cccbd"; logging-data="9398"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/I4AJ0cLU8yc/QoRs4DJ3g"
User-Agent	Pan/0.132 (Waxed in Black)
Cancel-Lock	sha1:M52bvoCAoACI822rq2aSJXrqBvA=
Xref	csiph.com comp.databases.oracle.misc:1032 comp.os.vms:70952

Cross-posted to 2 groups.

Show key headers only | 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