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
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
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: ------^^^^^^^^^^^^^^^^^^^^^^^^^^
In article <pan.2017.10.11.21.45.59@example.com>, Suntan
<nospam@example.com> writes:
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:
Dr. Tony Newman and Dr. Doug Phillips have once again been transported through time via The Time Tunnel.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 285 |
Nodes: | 16 (2 / 14) |
Uptime: | 76:19:20 |
Calls: | 6,489 |
Files: | 12,096 |
Messages: | 5,276,215 |