1.这样下载下来是UTF8格式的。
sqlplus "userdb/userdb@userdb" <
set serveroutput on
set feedback off
set trims on
set pagesize 0
set timing off
set lin 5000
set trimspool on;
spool /home/bmp/data/TaskControl/FileConvert/output/test/OCS_test.unl;
select t.accountkey,t.firstname from OCS_ACCT_EXTINFO t
where t.accountkey>=2040165458 and t.accountkey<=2040173910;
spool off
set serveroutput off
<162 vcp [bmp] :/home/bmp/data/TaskControl/FileConvert/output/test>file OCS_test.unl
OCS_test.unl: UTF-8 Unicode text
2.这样是ASCII格式的,
sqlplus "userdb/userdb@userdb" <
set colsep |;
set echo off;
set trim off;
set feedback off;
set heading off;
set pagesize 0;
set linesize 4090;
set numwidth 38;
set termout off;
set trimout on;
set trimspool on;
spool /home/bmp/data/TaskControl/FileConvert/output/test/test2.unl;
select accountkey,accountstat,
to_char(t.lastupdstattime,'yyyymmddhh24miss'),
t.firstname,
t.middlename,
t.lastname,
t.CorpAdminName
from ocs_acct_extinfo t
where to_char(t.applytime,'yyyyMMdd') < to_char(sysdate,'yyyyMMdd')
and to_char(t.expiretime,'yyyyMMdd') >= to_char(sysdate-1 ,'yyyyMMdd');
spool off;
<163 vcp [bmp] :/home/bmp/data/TaskControl/FileConvert/output/test>file test2.unl
test2.unl: ASCII text, with very long lines
感觉很诡异,自己没有时间分析,悲剧。各位帮忙看一下。