问题来啦:
我在bat文件(要准备xp和linux两个版本的批处理)中调用一个.sql文件:
bat文件: set UserId=np30/np168@RNTD
set CurDate=%date:~0,10%
set sqlLogFileName=sql-log-%curdate%
set LogPath=.\log\
sqlplus %UserId% @log.sql >%LogPath%%sqlLogFileName%.log
.sql文件内容: select t.*, t.rowid from np_syn_log t
输出的log: SQL*Plus: Release 10.2.0.1.0 - Production on 星期四 7月 9 14:14:46 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options