SQLPlus solve Chinese charactor error

最新推荐文章于 2022-07-27 11:13:15 发布

iteye_3787

最新推荐文章于 2022-07-27 11:13:15 发布

阅读量82

点赞数

文章标签： SQL DOS

本文链接：https://blog.csdn.net/iteye_3787/article/details/82003133

版权

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