How to query and modify Oracle character sets

It is not very common to query the character set modification Character Set of oracle.

Query the character set of Oracle

Method 1

SQL> select userenv ('language') from dual;

Userenv ('language ')

------------------

American_america.we8iso8859p1

Method 2

SQL> select * from V $ nls_parameters;

Parameter Value

--------------------------------------------

Nls_language American

Nls_territory America

Nls_currency $

Nls_iso_currency America

Nls_numeric_characters .,

Nls_calendar Gregorian

Nls_date_format DD-MON-RR

Nls_date_language American

Nls_characterset we8iso8859p1

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

Modify Character Set

Connect system/Oracle10g as sysdba;

Update props $ set value $ = 'utf8' where name = 'nls _ characterset ';

Shutdown immediate;

Startup Mount;

Alter system enable restricted session;

Alter system set job_queue_processes = 0;

Alter system set aq_tm_processes = 0;

Alter database open;

Alter database character set internal_use utf8;

Alter database National Character Set internal_use utf8;

Shutdown immediate;

Startup;

This is not very common. Please note.