for example: set pagesize 0 set linesize 250 set termout off set heading off set echo off set feedback off spool E:\特快稽核\load\recv_bag.txt select IN_SERIAL_NO||'^'||IN_TIME||'^'||RECV_STAFF_NO||'^'||RECV_TEAM||'^'||ORIGINAL_CODE||'^'||CARRIER||'^'||DESP_NO||'^'||BAG_NO||'^'||BAG_WEIGHT||'^'||BAG_TOTAL||'^'||EDIT_MODE||'^'||EDIT_STAFF||'^'||EDIT_TIME||'^'||RECV_STAFF_NO2||'^' from recv_bag; spool off set termout on set heading on set echo on set feedback on
set head off set linesize 1000 set pagesize 0 spool c:\tb01.txt select * from tb01 where ...; spool off;
desc tablename
//库记录:
select * from tablename;spool off;
edit temp.txt;
我希望输出格式如下:字段1值1 字段2值1 ...
字段1值2 字段2值1 ...
.
.
.
字段1值100 字段2值100其中中间不要段,就是说一直连续的,因为我希望转换成符合导入到SQL Server中的TXT的要求
set pagesize 0
set linesize 250
set termout off
set heading off
set echo off
set feedback off
spool E:\特快稽核\load\recv_bag.txt
select IN_SERIAL_NO||'^'||IN_TIME||'^'||RECV_STAFF_NO||'^'||RECV_TEAM||'^'||ORIGINAL_CODE||'^'||CARRIER||'^'||DESP_NO||'^'||BAG_NO||'^'||BAG_WEIGHT||'^'||BAG_TOTAL||'^'||EDIT_MODE||'^'||EDIT_STAFF||'^'||EDIT_TIME||'^'||RECV_STAFF_NO2||'^' from recv_bag;
spool off
set termout on
set heading on
set echo on
set feedback on
set linesize 1000
set pagesize 0
spool c:\tb01.txt
select * from tb01 where ...;
spool off;
.....spool off这种方法比较好用