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

Question

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

User · Answer

Try This   sqlplus -s   ORA CONN STR   lt  lt EOF  gt  dev null

User · Answer

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

User · Answer

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 gt   termout off

User · Answer

Try this   SET TERMOUT OFF   spool M  Documents test  select   from employees    spool off

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

Examples related to oracle

Examples related to sqlplus