📄 oracle++-
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Oracle技术网—如何查看数据库的字符集</title>
</head>
<link rel="stylesheet" href="../css/css.css">
<body topmargin="7" leftmargin="0" bgcolor=white text="black">
<table border="0" width="99%" cellspacing="3" cellpadding="0" bgcolor="#FFFFFF">
<tr bgcolor=E1E1FF align=right>
<td width=40% bgcolor=white><td>
<td><font color=black>
<a href="javascript:window.external.AddFavorite('http://www.oradb.net/','ORACLE技术网')" target="_top" title="ORACLE技术网">【加入收藏】</a>
<a href="../guestbk.htm" title="如果你对我们的网站有什么建议或意见，请留言">【访客留言】</a>
【聊天室】
<a href="../otherweb.htm">【技术站点导航】</a>
<a href="http://oradb.abc.yesite.com/">【技术论坛（BBS）】</a>
</font></td>
</tr>
</table>
<!--0-->
<script src="../comm/title2.htm"></script>
<!--0-->
<!--1-->
<script src="../comm/title3.htm"></script>
<!--1-->
<!--2-->
<table border="0" width="97%" height="20" cellspacing="0" cellpadding="0" bgcolor="#FFFFFF" align="center">
<tr><td>
位置：<a href=../default.asp>首页</a>→<a href=../dba.htm>DBA</a>→
</td></tr>
</table>
<!--2-->
<br>
<!--3-->
<table border="0" width="97%" cellspacing="0" cellpadding="0" align="center">
<tr>
<!--3.2-->
<td width="*" valign=top bgcolor=white align=right>
<table border="0" width="100%" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF" bordercolor="#000000" align=center>
<tr align=right><td><a href="mailto:oradb@126.com">阿木伯 著</td></tr>
<tr><td bgcolor=black></td></tr>
<tr align=center><td bgcolor=efffe0>如何查看数据库的字符集？</td></tr>
<tr><td><br></td></tr>
<tr><td>
<ul>
<li>软件环境：
<ul>
1、Windows NT4.0+ORACLE 8.0.4<br>
2、ORACLE安装路径为：C:\ORANT<br>
</ul>
</ul>
<ul>
<li>实现方法：
<pre>
SQL> conn sys/change_on_install
SQL> desc props$
SQL> set arraysize 1
SQL> col value$ format a40 --格式化value$的输出为40个字符宽
SQL> select name,value$ from props$ where name='NLS_CHARACTERSET';
SQL> conn system/manager
SQL> select * from nls_database_parameters;
SQL> select * from V$NLS_PARAMETERS;
SQL> select * from nls_database_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-YY
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_NCHAR_CHARACTERSET ZHS16GBK
NLS_RDBMS_VERSION 8.0.4.0.0
查询到12记录.
SQL> select * from V$NLS_PARAMETERS;
PARAMETER VALUE
---------------------------------------- -------------------
NLS_LANGUAGE SIMPLIFIED CHINESE
NLS_TERRITORY CHINA
NLS_CURRENCY RMB
NLS_ISO_CURRENCY CHINA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-YY
NLS_DATE_LANGUAGE SIMPLIFIED CHINESE
NLS_CHARACTERSET ZHS16GBK
NLS_SORT BINARY
NLS_NCHAR_CHARACTERSET ZHS16GBK
查询到11记录.
</pre>
</ul>
</td></tr>
<tr align=right><td>【最后更新：<font color=blue><script language="LiveScript">document.write(document.lastModified)</script></font>】</td></tr>
</table>
</td>
<!--3.2-->
</tr>
</table>
<!--3-->
<br><br><br>
<!--4-->
<script src="../comm/bottom1.htm"></script>
<!--4-->
<!--5-->
<script src="../comm/bottom2.htm"></script>
<!--5-->
<br>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -