脚本内容如下:
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;<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>
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;<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"></script>