oracle 利用sqlplus客户端的spool工具把查询出来的内容导到指定的文件中

来源：互联网发布：投影仪知乎编辑：程序博客网时间：2024/05/16 12:30

把下面的内容写到文件exp.sql

set verify off;
set wrap off;
set echo off;
set term off;
set heading off;
set feedback off;
set pagesize 0;
set linesize 32767;
set trimspool on;
SPOOL $HOME/saspblua/bin/data/jst/SAS_JST_SETT_$mydate.txt;
select TFTXCODE || '#' || TFTERMID || '#' || TFTEACCT || '####' || TFMCCODE || '#' || TFTMCCODE || '##02#' || TFTXMONY || '#' || TFACMONY || '#' || TFTEACCT || '#061#0000#' || to_char(TFACCTDT,'yyyymmdd') || '#' || TFTERMNO || '#' || to_char(TFDATE,'yyyymmddhh24miss') || '#' || TFTXDETA || '##' || '0899999951' || '##' || to_char(TFMERCDT,'yyyymmdd') || '##' || TFCARDTYPE || '###' from sasictxflow where to_char(tfdate,'yyyymmdd') = $mydate and TFMCCODE='000456' and TFBIZINFO='006' and TFMERSTU='2';
SPOOL OFF;
exit

然后利用sqlplus中登录，之后直接执行语句@exp.sql即可

1 0