sqlplus : How to turn off output to terminal ?
Atif Ahmad Khan
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
aa...@ra.msstate.edu
Bosse Melin
To turn of terminal output use:
set termout off
Best regards
Bosse Melin, Sweden
bosse...@gislaved.mail.telia.com
Atif Ahmad Khan <aa...@Ra.MsState.Edu> skrev i inlägg
<aak2.85...@Isis.MsState.Edu>...
AlexJent
You can't(dont' want) to do that. The only way for data to get to the
file there must be output from running your script.
However, if you are in a UNIX environment you can redirect the output to
the null device while you spool to a file. This will avoid collecting
massive amounts of data in log files etc.
Good luck.
Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954 E-Mail: inf...@aol.com
E-Mail Work: jenti...@notes.seagate.com
Home: Alex...@aol.com
John Morrison
Jorma Tirkkonen
I make file d:\temp\test.sql as
set echo off
set termout off
spool d:\temp\test.txt
select * from dict;
spool off
set termout on
set echo on
and then I ran it from sqlplus like
SQL> @d:\temp\test.sql
and "termout off" don't stop spooling result to file.
(Windows NT platform and SqlPlus 3.3)
Best regards Jorma
Dave Macpherson
Actually, that is not correct. You can SET TERMOUT OFF and still spool
the output to a file.
Dave
janet
>
> How do I turn off output to terminal sqlplus from a select statement when I
> am spooling the result to a text file ?
>
> You can't(dont' want) to do that. The only way for data to get to the
> file there must be output from running your script.
Not my understanding.
set termout off
spool spoolfile.lst
select * ...
spool off
and your spool file contains the select data.
janet
Kari Pannila
On 28 Feb 1997 12:59:56 -0600, aa...@Ra.MsState.Edu (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.
Have you tried " set flush off" ?
rgrds Kari
Brian Motzer
Use set termout off
AlexJent
If you are running on a unix platform, I would suggest NOT running your
script from within SQLPLUS when spooling large data but run from the unix
prompt.
IE: sqlplus -s username/password @yourscript.sql > spooldata.txt
Actually with this method, you should not have a "spool" statement in your
script.
If you are not on a unix platform....I'll be looking at responces you
receive....
Jerry Apfelbaum
The option to use is: set termout off
There are some restrictions, though. 'set termout off' will only work
if you are running an external SQL script (eg, start sqlscript.sql). It
does not work for an interactive query from the keyboard.
Furthermore, if you are using UNIX and the SQL is in an in-line redirect
(aka, a here document), then 'set termout off' will not work either
because SQL*Plus still thinks it is interactive input. The following is
a simple example of such a case:
sqlplus -s username/password << endOfSQL
set termout off
select * from emp;
endOfSQL
In the above UNIX script, the 'set termout off' will NOT stop output to
standard output. This is because UNIX passes the 'SQL script' to
SQL*Plus as if it were interactively input through the keyboard. One
way I have used to get around this is to pipe the output of the
SQL*Plus, such as:
sqlplus -s username/password << endOfSQL | grep -E "^ORA-|^ERROR"
select * from emp;
endOfSQL
In the above example, your terminal would only show you Oracle error
lines. Other variants are obviously possible according to your needs.
Hope this helps.
=================================================
Jerry Apfelbaum email: japf...@ican.ca
Eastern Sun Group Inc. phone: 416.769.8738
Toronto, Canada fax: 416.769.7428
Richard J Woodland
A related question... When using SQL*PLUS under WIndows 95, each query
results in an annoying popup which simply states the obvious (Query in
progress). Anybody know of any way to suppress this?
KJPhilbr13
Try "set term off"...
Regards,
Kevin
Mark Killick
In message <19970318131...@ladder01.news.aol.com>
kjphi...@aol.com (KJPhilbr13) writes:
> Regards,
> Kevin
or when invoking sqlplus with input coming from a script 'sqlplus -s'
regards,
Mark Killick
Keith/Loo Yah
Kari Pannila wrote:
>
> On 28 Feb 1997 12:59:56 -0600, aa...@Ra.MsState.Edu (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.
>
> Have you tried " set flush off" ?
>
> rgrds Kari
That should do the trick.
Cheers!
Keith
k.srilat...@gmail.com
ddf
> That dint work. I have the same issue. Any other way to turn it off?
David Fitzjarrell
pravesh...@paytm.com
joel garry
> You All sucked nobody having understand of practical.There is no working Termout off to disappearing query output on terminal.search other method in linux.
Do you not understand how old this thread is? What kind of strange access do you have to usenet? Have you any idea who the people are here? Do you have any idea what this group is about? Were you even born when it was created? Did Oracle run on linux when this thread was started?
See http://www.dbaoracle.net/readme-cdos.htm
jg
--
@home.com is bogus.
http://news.softpedia.com/news/Oracle-Linux-7-0-RC-Uses-XFS-Filesystem-and-Has-UEFI-Support-448681.shtml
cnea...@itree.com.au
sqlplus -s username/password << endOfSQL > /dev/null
suho...@gmail.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.
>
>
> Atif Khan
> aa...@ra.msstate.edu
This is interesting topic. I found it today. hope it is useful.
sqlplus "%usr_name%/%pass%@%db" @sqlscript.sql > suppressed.out
Suntan
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).
VAXman-
>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.
--
VAXman- A Bored Certified VMS Kernel Mode Hacker VAXman(at)TMESIS(dot)ORG
I speak to machines with the voice of humanity.
Suntan
> In article <pan.2017.10...@example.com>, Suntan
> <nos...@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.
crept in).