oracle中sql生成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;

$ more insert.sh
#!/bin/bash
. /export/home/oracle/.profile
sqlldr user/password control=/export/home/oracle/test/insert.ctl
$ more insert.ctl
load data
infile 'name.txt'--------------说明下，这里可以换成是csv文件或是用tab键分隔的txt文件；
append into table table_name
fields terminated by '  ' -----------------(各个字段的分隔符，是tab或逗号等)
(id,
content,
……)
$./insert.sh