sqlplus里怎么切换输入法啊?为什么按ctrl+shift不行,按alt+shift也不行,不知道还有没有其他办法啊?
解决方案 »
- 大家来讨论下oracle erp都涉及到哪些技术?
- 用pb导入数据问题
- 空表查询用了3秒!是什么问题导致的列?
- oracle的ISQ*PLUS的HTTP端口号怎么把它查出来,还有EM的端口号?
- Oracle10g表空间设置问题
- ORACLE与SQLSERVER问题
- linux、oracle双机数据库安装问题!
- DB2如何导数据到ORACLE?
- ★★前途迷茫!!怎么样的水平才能找到ORACLE开发的工作????我要喝西北风了!!
- 如何查看mview是基于rowid还是主键
- oracle里面有乘积的聚合函数吗,如sum是相加的,我要个相乘的,有吗
- 急:在RHEL 4下面安装Oracle 10g,报OUI-10118错误:加载安装组件时products.xml文件不存在或者读取失败
SQL> select * from V$NLS_PARAMETERS; PARAMETER VALUE
------------------------------ ------------------------------------
NLS_LANGUAGE SIMPLIFIED CHINESE !!!!
NLS_TERRITORY CHINA !!!!
NLS_CURRENCY ¥
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK !!!!
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY ¥
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE 已选择19行。
查看客户端的字符集设置:
注册表里面的nls_lang项 我的为"SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
不一样的话把两个设为一样就可以了.
------------------------------------------------------------
网上看到的,希望有帮助
还有建议使用PLSQL
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_LANGUAGE
SIMPLIFIED CHINESENLS_TERRITORY
CHINANLS_CURRENCY
¥
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_ISO_CURRENCY
CHINANLS_NUMERIC_CHARACTERS
.,NLS_CALENDAR
GREGORIAN
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_DATE_FORMAT
DD-MON-RRNLS_DATE_LANGUAGE
SIMPLIFIED CHINESENLS_CHARACTERSET
ZHS16GBK
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_SORT
BINARYNLS_TIME_FORMAT
HH.MI.SSXFF AMNLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_TIME_TZ_FORMAT
HH.MI.SSXFF AM TZRNLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZRNLS_DUAL_CURRENCY
¥
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_NCHAR_CHARACTERSET
AL16UTF16NLS_COMP
BINARYNLS_LENGTH_SEMANTICS
BYTE
PARAMETER
----------------------------------------------------------------
VALUE
----------------------------------------------------------------
NLS_NCHAR_CONV_EXCP
FALSE
已选择19行。