set trimspool on
set linesize 120
set pagesize 2000
set newpage 1
set heading off
set term off
spool 路径+文件名
select col1||','||col2||','||col3||','||col4||'..' from tablename;
spool off ;下面这样写对吗?
select sum(case when a.name = 'aaa' then a.XX end) from dual?
不识别 a.name = 'aaa'
set linesize 120
set pagesize 2000
set newpage 1
set heading off
set term off
spool 路径+文件名
select col1||','||col2||','||col3||','||col4||'..' from tablename;
spool off ;下面这样写对吗?
select sum(case when a.name = 'aaa' then a.XX end) from dual?
不识别 a.name = 'aaa'
select sum(case when a.name = 'aaa' then a.XX end) from a