oralce 匯出csv格式檔案

set colsep ,  
set feedback off  
set heading off  
set trimout on  
set pagesize 0
set linesize 1000
spool /scripts/ALI_20160715_OUTPUT.csv
select '"' ||REGNO|| '","' || CREDIT_CODE || '","' || ENTNAME || '","' ||NAME|| '","' || CERNO || '"'  from ALI_20160715_OUTPUT;          
select '' ||REGNO|| ',' || CREDIT_CODE || ',' || ENTNAME || ',' ||NAME|| ',' || CERNO || ''  from ali_20160715_output_cerno;                                                                              
spool off;