CODEWITHSUNDEEP
oracle-databasesqlplus
simplfuzz
simplfuzz

Reputation: 12935

Oracle SqlPlus - saving output in a file but don't show on screen

Using SqlPlus for Oracle, how do I save the output of a query in a file but not show it on the terminal/prompt.

Upvotes: 47

Views: 183750

Answers (4)

user330315
user330315

Reputation:

Right from the SQL*Plus manual
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/ch8.htm#sthref1597

SET TERMOUT

SET TERMOUT OFF suppresses the display so that you can spool output from a script without seeing it on the screen.

If both spooling to file and writing to terminal are not required, use SET TERMOUT OFF in >SQL scripts to disable terminal output.

SET TERMOUT is not supported in iSQL*Plus

Upvotes: 55

pelms
pelms

Reputation: 1242

set termout off doesn't work from the command line, so create a file e.g. termout_off.sql containing the line:

set termout off

and call this from the SQL prompt:

SQL> @termout_off

Upvotes: 3

Ashish Anand
Ashish Anand

Reputation: 3581

Try This:

sqlplus -s ${ORA_CONN_STR} <<EOF >/dev/null

Upvotes: 12

Mohammad
Mohammad

Reputation: 221

Try this:

SET TERMOUT OFF; 
spool M:\Documents\test;
select * from employees;
/
spool off;

Upvotes: 22

Related Questions