Re: how to suppress query output in the command window?

From: Malcolm Dew-Jones <>
Date: 21 Aug 2008 17:08:31 -0800
Message-ID: <48ae037f$>

Xu ( wrote:
: Dear Oracle users:

: I have a very simple test.sql file shown below:
: ============
: set echo off
: set feedback off

: spool C:\test.log

: select* from
: dbname.tablename
: /
: spool off
: exit
: ==============

: When I submitted in Windows command window as the following:

: C:\>sqlplus loginname/password_at_dbname @test.sql

: The output of the select statement was displayed in the command window
: (rows after rows were rolling the window). How to avoid the output
: rolling thru the command window (since I spool the output already)? I
: tried the silent mode below and the output still rolled thru the
: window !

: C:\>sqlplus -s loginname/password_at_dbname @test.sql

That is not what silent mode does.

What you want is the SET command, run within sqlplus. In the script, before the select statement, put the command

        SET TERMOUT OFF Received on Thu Aug 21 2008 - 20:08:31 CDT

Original text of this message