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;
-----------------------------------------------------
-
set colsep ,
-
set feedback off
-
set heading off
-
set trimout on
-
spool D:\DBoracle\lfc.csv
-
select '"' || user_name || '","' || user_age || '","' || user_card || '","' || user_sex || '","' || user_addres || '","' || user_tel || '"' from lfc_xinxi_tbl;
-
spool off
-
exit
阅读(1880) | 评论(0) | 转发(1) |