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

最新推荐文章于 2024-04-11 13:30:13 发布

wzjudy

最新推荐文章于 2024-04-11 13:30:13 发布

阅读量783

点赞数 1

本文链接：https://blog.csdn.net/u011125324/article/details/70308046

版权

把下面的内容写到文件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即可