可以试试这个[Q]怎么样把查询内容输出到文本 [A]用spool如 如sqlplus –s " / as sysdba" <<EOF set heading off set feedback off spool temp.txt select * from tab; dbms_output.put_line(‘test’); spool off exit EOF
在SQLPLUS中执行 set heading off set feedback off set linesize 3000 spool c:\123.txt select 列名1||'|'||列名2||'|'||列名3 ||'|'||列名4 ||'|'||列名5...... from t1; spool off
[A]用spool如
如sqlplus –s " / as sysdba" <<EOF
set heading off
set feedback off
spool temp.txt
select * from tab;
dbms_output.put_line(‘test’);
spool off
exit
EOF
set heading off
set feedback off
set linesize 3000
spool c:\123.txt
select 列名1||'|'||列名2||'|'||列名3 ||'|'||列名4 ||'|'||列名5...... from t1;
spool off