oracle sqlplus 导出csv文件

set linesize 3000; 
set heading off; 
set feedback off; 
set term off; 
set pagesize 0; 
set trimspool on; 
spool a.csv; 
select c1_name||','||c2_name from dual; 
select c1||','||c2 from tbtest 
spool off; 


-----------------------------------------------------

1. set colsep ,
2. set feedback off
3. set heading off
4. set trimout on
5. spool D:\DBoracle\lfc.csv
6. select '"' || user_name || '","' || user_age || '","' || user_card || '","' || user_sex || '","' || user_addres || '","' || user_tel || '"' from lfc_xinxi_tbl;
7. spool off
8. exit