|
echo "
set newpage 0
set space 0
set linesize 134
set pagesize 0
set trims off
set trimspool off
set echo off
set feedback off
set verify off
set heading off
set markup html off spool off
set colsep ''
col RECORD_TYPE format a2
col ORG_CALLER_NUM format a20
col ORG_CALLEE_NUM format a28
col START_TIME format a12
col CALL_SECONDS format a8
col IN_TRUNK format a7
col OUT_TRUNK format a7
col TRANS_CODE format a28
col TRANS_PARAM format a8
col TRAFFICTYPE format a3
col BAREAR_TYPE format a2
col FILE_ID format a9
set termout off
spool $file
$sqlcmd;
spool off
exit
" > backout.sql
sqlplus user/pwd@ora @backout.sql
我在shell里加了上面的spool,想生成一个定长的文件,如果里的面的字段全是varchar2型的就没有问题,如果字段里有number型的就会出错,文件显示了很多"#",不知道如何解决,是不是“col CALL_SECONDS format a8”这个用法,不能对number型字段设占的长度? |
|