set feed off pause off pages 0 head off veri off line 500 set term off time off trims on set sqlprompt '' set colsep , spool abcdef.csv select column1,column2,column3 from table spool off
set feed off pause off pages 0 head off veri off line 500 set term off time off trims on set sqlprompt '' set colsep , spool abcdef.csv select column1,column2,column3 from table spool off
调整好格式,把结果打印到一个文件中,
然后再用脚本处理导出的结果文件,
最后用excel的导入功能导入即可。
set term off time off trims on
set sqlprompt ''
set colsep ,
spool abcdef.csv
select column1,column2,column3 from table
spool off
set term off time off trims on
set sqlprompt ''
set colsep ,
spool abcdef.csv
select column1,column2,column3 from table
spool off
用excel的另存为就行