17,377
社区成员
发帖
与我相关
我的任务
分享set NLS_LANG问题
set NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5
这句在应该在哪里执行
在SQL*Plus工作单中出现
SP2-0735: 未知的 SET 选项开头"NLS_LANG=A..."
在CMD.exe下
执行后好像没起作用
这句在应该在哪里执行
在SQL*Plus工作单中出现
SP2-0735: 未知的 SET 选项开头"NLS_LANG=A..."
在CMD.exe下
执行后好像没起作用
...全文
请发表友善的回复…
发表回复
wffffc 2008-12-26
- 打赏
- 举报
C:\Documents and Settings\Administrator>sqlplus wf/oracle
SQL*Plus: Release 11.1.0.6.0 - Production on 星期五 12月 26 23:42:30 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
C:\Documents and Settings\Administrator>set NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5
C:\Documents and Settings\Administrator>sqlplus wf/oracle
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Dec 26 23:42:56 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
SQL*Plus: Release 11.1.0.6.0 - Production on 星期五 12月 26 23:42:30 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
C:\Documents and Settings\Administrator>set NLS_LANG=AMERICAN_AMERICA.ZHT16BIG5
C:\Documents and Settings\Administrator>sqlplus wf/oracle
SQL*Plus: Release 11.1.0.6.0 - Production on Fri Dec 26 23:42:56 2008
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
Divina 2008-12-26
- 打赏
- 举报
我都是直接修改的注册表.
CMD ->REGEDIT -> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\NLS_LANG 设置成 对应字符集
CMD ->REGEDIT -> HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\NLS_LANG 设置成 对应字符集
范佩西_11 2008-12-25
- 打赏
- 举报
windows直接注册表改
我的位置如下：
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\NLS_LANG
我的位置如下：
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1\NLS_LANG
又是违规昵称 2008-12-25
- 打赏
- 举报
alter session set nls_language=AMERICAN;
alter system set nls_language=AMERICAN scope = spfile;
alter system set nls_language=AMERICAN scope = spfile;
