How to view and modify the oracle Character Set and view the oracle version ?, Oracle Character Set
1. view the database Character Set
Database Server Character Set select * from nls_database_parameters, which is derived from props $ and represents the character set of the database.
Client Character Set environment select * from nls_instance_parameters, which is from v $ parameter,
Indicates the character set setting of the client, which may be a parameter file, environment variable, or registry.
Select * from nls_session_parameters in the session Character Set environment, which is derived from v $ nls_parameters, indicating the session's own settings, which may be the session environment variable or the session is completed by alter session. If the session has no special settings, it will be consistent with nls_instance_parameters.
The character set of the client must be the same as that of the server to correctly display non-Ascii characters of the database. If multiple settings exist, alter session> environment variable> registry> parameter file
The character set must be consistent, but the language settings can be different. We recommend that you use English for language settings. If the character set is zhs16gbk, The nls_lang can be American_America.zhs16gbk.
2. Modify Character Set
For 8i or later versions, you can use alter database to modify the character set, but only the subset to the superset. We do not recommend that you modify the props $ table, which may cause serious errors.
Startup nomount;
Alter database mount exclusive;
Alter system enable restricted session;
Alter system set job_queue_process = 0;
Alter database open;
Alter database character set zhs16gbk;
3. How to view the database version
Select * from v $ version
Including version information, core version information, and number of digits (32-bit or 64-bit)
For the number of digits, you can use file to view the information on the Linux/unix platform, as shown in
File $ ORACLE_HOME/bin/oracle