SQL*Plus: Release 11.2.0.1.0 Production on 星期二 3月 29 14:31:29 2011Copyright (c) 1982, 2010, Oracle. All rights reserved.请输入用户名: system 输入口令:连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select * from v$nls_parameters;PARAMETER ---------------------------------------------------------------- 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
谢谢各位了,问题解决,主要是系统是x64,所以导致我安装pl/sql时,用的instantclient连接的数据库,原本sql plus没问题,不知何时我操作的时候导致sql plus查询是中文也显示了乱码,重装了下oracle,pl/sql查询是乱码,sql plus 正常,明白是因为pl/sql无环境变量的原因......悲剧,整了一天,就这问题......
SQL*Plus: Release 11.2.0.1.0 Production on 星期二 3月 29 14:31:29 2011Copyright (c) 1982, 2010, Oracle. All rights reserved.请输入用户名: system
输入口令:连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> select * from v$nls_parameters;PARAMETER
----------------------------------------------------------------
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
而是和你输入时候的字符集有关
想起来了,安装好pl/sql后,好像是通过pl sql导入的数据,然后我用sql plus查询数据就出现问号了.....