How to view and modify the Oracle encoding format method

--View the Oracle database character set:

Select Userenv (' language ') from dual;

Query Result:

Simplified Chinese_china. Al32utf8

--Modifying the Oracle Database Character set: (In SQL Plus)

Sql> Conn/as sysdba;

sql> shutdown immediate;

Database closed.

Database dismounted.

Oracle instance shut down.

sql> startup Mount;

Oracle instance started.

Total system global Area 135337420 bytes

Fixed size                        452044 bytes

Variable Size                   109051904 bytes

Database Buffers            25165824 bytes

Redo Buffers                    667648 bytes

Database mounted.

Sql> alter system enable restricted session;

System altered.

Sql> alter system set job_queue_processes=0;

System altered.

Sql> alter system set aq_tm_processes=0;

System altered.

sql> ALTER DATABASE open;

Database altered.

Sql> ALTER DATABASE character set Internal_use UTF8

sql> shutdown immediate;

Sql> startup;

How to view and modify the Oracle encoding format method