spool

set echo off
set feedback off
set newpage 0
set verify off
set term on
set trims off
set heading  off
set timing off
set verify off
SPOOL  d:/test.txt
select s.stockid||','||s.userid||','||s.model||','||s.maker||','||s.amount||','||s.lotnumber||','||s.price||','||state||','||encapsulation||','||vouch||','||spotgoods||','||keyword from sysicstocks s where s.stockid in (select i.stockid from sysicstock i);
SPOOL OFF