sqlplus test/test@testdb<< EOF
SPOOL /opt/XXXXX/XXXXXXX.txt
SET LINESIZE 100
SET PAGESIZE 50
select *
from test;
SPOOL OFF
exit;
EOF
sqlplus test/test@testdb<< EOF
SPOOL /opt/XXXXX/XXXXXXX.txt
SET LINESIZE 100
SET PAGESIZE 50
select *
from test;
SPOOL OFF
exit;
EOF
转载于:https://my.oschina.net/u/2308739/blog/818324