ID NAME C
--- ------------------------------ -
a01 鍖荤枟鍣ㄦ C
a03 瑗胯嵂 C
c04 鎬婚儴 A
d01 鐢茬骇鍖婚櫌 B
d02 涔欑骇鍖婚櫌 B
d03 涓欑骇鍖婚櫌 B
d04 鑽簵 B
d05 鍏朵粬 B
查询用户的时候出现乱码网上的方法试了不少希望大家帮帮忙!
--- ------------------------------ -
a01 鍖荤枟鍣ㄦ C
a03 瑗胯嵂 C
c04 鎬婚儴 A
d01 鐢茬骇鍖婚櫌 B
d02 涔欑骇鍖婚櫌 B
d03 涓欑骇鍖婚櫌 B
d04 鑽簵 B
d05 鍏朵粬 B
查询用户的时候出现乱码网上的方法试了不少希望大家帮帮忙!
解决方案 »
- Oracle第三方开发工具对比
- ORACLE中的两条SQL语句问题
- 关于oracle类型 <CLOB> ,急急。
- 有关备份回滚脚本
- Oracle游标学习资料
- OC4J、DatabaseControl、emctl、grid control是什么, 有什么区别?他们对于数据库和实例的关系?
- 我在oms中导出数据库数据,遇到错误如下:已经添加了节点首选项证明,以及将备份用户设置为作为批处理用户登陆阿
- 一用户具有能操作某功能,但是只能操作此功能下的某些数据,如何设置此用户的操作这些数据的权限?
- 一个关于行触发器的问题
- oracle 不同表数据求和问题
- 寻找pl/sql总结文档
- 求一个段sql脚本!!!!急
sqlplus "/as sysdba"
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 235999352 bytes
Fixed Size 450680 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
SQL> alter session set sql_trace=true;
Session altered.
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> set linesize 120;
SQL> alter database character set zhs16gbk;
alter database character set zhs16gbk
*
ERROR at line 1:
ORA-12712: new character set must be a superset of old character set
SQL> ALTER DATABASE character set INTERNAL_USE zhs16gbk; # 使用INTERNAL_USE可以跳过超集的检查,ALTER DATABASE character set INTERNAL_USE
Database altered.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.
Total System Global Area 235999352 bytes
Fixed Size 450680 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.