anybody know how to NOT show the SQL> prompt and statement when spooling to a file?
"I pledge to stop eating sharks fin soup and will not do so under any circumstances."
Put it all into a .sql file and run it from sql*plus:
set heading off feedback off pagesize 0 echo off
select * from test
In this case, the contents of test.txt were:
Oracle DBA and Developer