SQLplus命令中导出数据

SQL:spool E:/test.xls;

SQL: create  table test_his as select * from test where 1=2;

SQL:spool off;

这里可以选择xls.txt等后缀