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@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@dbname @test.sql

Thank you very much!

Xu (xuzengpj (AT) gmail (DOT) com) 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@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@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

Xu (xuzengpj (AT) gmail (DOT) com) 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@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@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

Xu (xuzengpj (AT) gmail (DOT) com) 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@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@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

Xu (xuzengpj (AT) gmail (DOT) com) 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@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@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