查看和修改Oracle数据库字符集

1、查询oracle server端的字符集 SQL> select userenv('language') from dual;USERENV('LANGUAGE') ---------------------------------------------------- AMERICAN_AMERICA.ZHS16GBK或者SQL> set line 150 SQL> col parameter for a30 SQL> col value for a30 0 Comments

1、查询oracle server端的字符集

SQL> select userenv('language') from dual;USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK或者SQL> set line 150
SQL> col parameter for a30
SQL> col value for a30
SQL> select * from nls_database_parameters;PARAMETER		       VALUE
------------------------------ ------------------------------
NLS_LANGUAGE		       AMERICAN
NLS_TERRITORY		       AMERICA
NLS_CURRENCY		       $
NLS_ISO_CURRENCY	       AMERICA
NLS_NUMERIC_CHARACTERS	       .,
NLS_CHARACTERSET	       ZHS16GBK
NLS_CALENDAR		       GREGORIAN
NLS_DATE_FORMAT 	       DD-MON-RR
NLS_DATE_LANGUAGE	       AMERICAN
NLS_SORT		       BINARY
NLS_TIME_FORMAT 	       HH.MI.SSXFF AMPARAMETER		       VALUE
------------------------------ ------------------------------
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

本文链接：https://my.lmcjl.com/post/9404.html

展开阅读全文

相关文章

4 评论

留下您的评论.