oracle中sql生成csv文件

SET HEADING OFF
SET TRIMSPOOL ON
SET TRIMOUT ON
SET FEEDBACK OFF
SET PAGESIZE 0
SET LINESIZE 2000
SET ARRAYSIZE 5000
SET TERM OFF
SET SQLBLANKLINES ON


PROMPT spooling test csv
SPOOL test.csv 

select 'test' from dual;

SPOOL OFF
/