Spool without SQL Statement and Commands in PLSQL [message #487948] |
Mon, 03 January 2011 13:48 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/149b2c057dc5f3c266ebdecbc0f339e4?s=64&d=mm&r=g) |
KoolK
Messages: 2 Registered: January 2011
|
Junior Member |
|
|
I have a PLSQL script.
sqlplus
$DB_ACCT << EOSQL
set heading off
set termout off
set pagesize 0
set linesize 35
set feedback off
set serveroutput off
spool FILE.txt
Select col_with_a||col_with_b||col_with_c from alphabet_table;
spool off;
exit;
EOSQL
My output in FILE.txt looks like this
SQL>
SQL> Select col_with_a||col_with_b||col_with_c from
2 alphabet_table;
abc
abc
abc
abc
abc
abc
abc
SQL>
SQL> spool off;
I tried several options by putting set echo off, etc.
What do I include in the sql script to get the output as :
abc
abc
abc
without the SQL prompt and the statement, and the spool off command?
|
|
|
|
|