Oracle导出数据到csv文件方法

SET COLSEP ','
SET LINESIZE 1000
SET PAGESIZE 0
SPOOL d:\output.csv
SELECT * FROM table_name;
SPOOL OFF