SQLPlus solve Chinese charactor error

原创于 2011-01-26 13:51:56 发布 · 103 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#SQL #DOS

本文介绍如何通过SQLPlus工具批量执行多个SQL脚本文件，包括设置字符集、登录数据库、执行特定路径下的脚本列表及日志记录等关键步骤。

First of all, run the sqlplus.

1. open cmd and input follow script (*Setup charactor to make the chinese script is correct.)

--setup charactor(DOS)(UTF8)
echo %NLS_LANG%
set NLS_LANG=AMERICAN_AMERICA.UTF8

2. input "sqlplus".

3. input database information："app_dev/app_devpwd@o1234g"

4. use follow commond to run sql list: "@@D:\dbscript\script_list.sql"

5. The "script_list.sql" should be:

whenever oserror exit rollback
whenever sqlerror exit rollback
set define off
set feedback on
set echo on
SET TERMOUT on

spool upgrade_script_.log
----------------------------------------------------

@@APP/PUB/201101121752_dml_1.sql
commit;
@@APP/PUB/201102021541_dml_2.sql
commit;

----------------DBScript Execute Success------------
spool off

quit