set TRIM off set TAB off set heading off set termout off set LIN 4000 set PAGES 10000 spool date_log.csv select 'col1,col2,col3,col4,col5,col6,col7' from dual --上句是控制表头的字段名,且上述字段名要与下的脚本字段统一。 UNION ALL select col1 || ',' || col2 || ',' || col3 || ',' || col4 || ',' || col4 || ',' || col5 || ',' || col6 ||
oracle导出格式:set TRIM offset TAB off set heading off set termout offset LIN 4000set PAGES 10000spool date_log.csvselect 'col1,col2,col3,col4,col5,col6,col7' from dual--上句是控制表头的字段名,且上述字段名要与下的脚本字段统一。UNI