oracle使用sql脚本生成csv文件案例学习
程序员文章站
2023-12-01 23:45:22
脚本内容如下： 复制代码 代码如下: set linesize 3000; set heading off; set feedback off; set term off;...
脚本内容如下：
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 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;