Spool query to file without output on screen

Question

Using spool on Oracle sqlplus correctly sends the results of my queries to a file.

But I also see output on the screen.

Is it possible to see only the query without output on screen, and result on file? (This feature is the default on PostgreSQL psql client program).

Answer 1

You can use SQL> SET TERMOUT OFF command to get the result.

Here are some useful links collected from comments:

• Oracle SqlPlus - saving output in a file but don't show on screen
• sqlplus, how to stop output to console
• How to make sqlplus output appear in one line?
• Remove blank lines from csv using shell script for oracle