导出脚本如下:
set echo off;
set head off;
set feedback off;
set verify off;
set term off;
set trims on;
set numwidth 20;
set newpage none;
spool &1;
set linesize 2000;
select * from t1
where date=&2;
select * from t2
where date=&2;
....
set spool off;
set num 10;
set newpage 1;
set trims off;
set term on;
set verify on;
set linesize 80;
set feedback on;
set head on;
set echo on;
exit;
原来在8i下用都好的,但移到9i下时,spool出来的字段都变长了。
不明确
不应该啊 设置格式的
set echo off;
set head off;
set feedback off;
set verify off;
set term off;
set trims on;
set numwidth 20;
set newpage none;
spool &1;
set linesize 2000;
这些东东不会有版本差异啊
看看是不是字符集的问题