相关链接

Oracle数据类型限制

<div class="WordSection1" style="layout-grid:15.6pt">
<table class="MsoNormalTable" style="margin-left: 4.65pt; border-collapse: collapse;" width="639" height="2272" cellspacing="0" cellpadding="0" border="0"> <tbody> <tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:13.5pt"> <td style="width:202.0pt;background:#3F3F3F;padding:0cm 5.4pt 0cm 5.4pt; height:13.5pt" width="269"> 数据类型<o:p></o:p> </td> <td style="width:218.0pt;background:#3F3F3F;padding:0cm 5.4pt 0cm 5.4pt; height:13.5pt" width="291"> 限制<o:p></o:p> </td> <td style="width:167.0pt;background:#3F3F3F;padding:0cm 5.4pt 0cm 5.4pt; height:13.5pt" width="223"> 注释<o:p></o:p> </td> <td style="width:257.0pt;background:#3F3F3F;padding:0cm 5.4pt 0cm 5.4pt; height:13.5pt" width="343"> 含义<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:1;height:96.0pt"> <td rowspan="4" style="width:202.0pt;border:solid windowtext 1.0pt; mso-border-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:96.0pt" width="269"> BFILE<o:p></o:p> </td> <td style="width:218.0pt;border:solid windowtext 1.0pt;border-left: none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:96.0pt" width="291"> Maximum size: 4 GB 文件最大4G<o:p></o:p> </td> <td rowspan="4" style="width:167.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt: solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:96.0pt" width="223"> The maximum number of BFILEs is limited by the value of the SESSION_MAX_OPEN_FILES initialization parameter, which is itself limited by the maximum number of open files the operating system will allow. BFILE最大可打开数量由参数SESSION_MAX_OPEN_FILES 决定 而SESSION_MAX_OPEN_FILES参数的最大值由操作系统允许打开的最大文件数量所决定<o:p></o:p> </td> <td style="width:257.0pt;border:solid windowtext 1.0pt; border-left:none;mso-border-top-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;padding: 0cm 5.4pt 0cm 5.4pt;height:96.0pt" width="343" valign="bottom" nowrap=""> Oracle bfile类型文件最大可以有4G<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:2;height:27.0pt"> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="291"> Maximum size of a file name: 255 characters 文件名最长255字符<o:p></o:p> </td> <td style="width:257.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="343" valign="bottom" nowrap=""> Oracle bfile类型文件名最长255字符<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:3;height:27.0pt"> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="291"> Maximum size of a directory name: 30 characters 目录名最长30字符<o:p></o:p> </td> <td style="width:257.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="343" valign="bottom" nowrap=""> Oracle bfile目录名最长30字符<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:4;height:54.0pt"> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:54.0pt" width="291"> Maximum number of open BFILEs: see Comments 最大可以同时打开的熟练参见注释<o:p></o:p> </td> <td style="width:257.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:54.0pt" width="343" valign="bottom"> Oracle bfile最大可以同时打开的数量 由SESSION_MAX_OPEN_FILES决定 而此值又与操作系统相关<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:5;height:81.0pt"> <td style="width:202.0pt;border:solid windowtext 1.0pt;border-top: none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:81.0pt" width="269"> BLOB<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:81.0pt" width="291"> Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB) 最大大小为 (4 GB - 1) * DB_BLOCK_SIZE. 根据块大小不同范围为8TB到128TB.<o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:81.0pt" width="223"> The number of LOB columns per table is limited only by the maximum number of columns per table 一个表中可包含的LOB列的多少由表中最大列数量决定<o:p></o:p> </td> <td style="width:257.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:81.0pt" width="343" valign="bottom"> Oracle BLOB 最大大小为(4 GB - 1) 个块 根据块大小不同,最大值可为8T到128T<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:6;height:27.0pt"> <td style="width:202.0pt;border:solid windowtext 1.0pt;border-top: none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:27.0pt" width="269"> CHAR<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="291"> Maximum size: 2000 bytes CHAR类型最长为2000字节<o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="223"> None<o:p></o:p> </td> <td style="width:257.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="343" valign="bottom" nowrap=""> Oracle char类型最多可以有2000字节<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:7;height:27.0pt"> <td style="width:202.0pt;border:solid windowtext 1.0pt;border-top: none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:27.0pt" width="269"> CHAR VARYING<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="291"> Maximum size: 4000 bytes CHAR 变量最长为4000 字节<o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="223"> None<o:p></o:p> </td> <td style="width:257.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="343" valign="bottom" nowrap=""> Oracle char类型变量最多可以有4000字节<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:8;height:95.25pt"> <td style="width:202.0pt;border:solid windowtext 1.0pt;border-top: none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:95.25pt" width="269"> CLOB<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:95.25pt" width="291"> Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB) The number of LOB columns per table is limited only by the maximum number of columns per table 最大大小为 (4 GB - 1) * DB_BLOCK_SIZE. 根据块大小不同范围为8TB到128TB.<o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:95.25pt" width="223"> <a href="http://docs.oracle.com/database/122/REFRN/datatype-limits.htm#fnsrc_d2172132e254">The number of LOB columns per table is limited only by the maximum number of columns per table (that is, 1000Footref ).</a><o:p></o:p> </td> <td style="width:257.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:95.25pt" width="343" valign="bottom"> Oracle BLOB 最大大小为(4 GB - 1) 个块 根据块大小不同,最大值可为8T到128T<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:9;height:27.0pt"> <td style="width:202.0pt;border:solid windowtext 1.0pt;border-top: none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:27.0pt" width="269"> Literals (characters or numbers in SQL or PL/SQL)<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="291"> Maximum size: 4000 characters 字面值:最长4000个字节<o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="223"> None<o:p></o:p> </td> <td style="width:257.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="343"> Oracle 字面值最长可以有4000字节<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:10;height:27.75pt"> <td style="width:202.0pt;border:solid windowtext 1.0pt;border-top: none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:27.75pt" width="269"> LONG<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.75pt" width="291"> Maximum size: 2 GB - 1 最长大小为 2GB-1<o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.75pt" width="223"> Only one LONG column is allowed per table.<o:p></o:p> </td> <td style="width:257.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:27.75pt" width="343" valign="bottom" nowrap=""> Oracle LONG 类型最大大小为2GB-1<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:11;height:27.0pt"> <td style="width:202.0pt;border:solid windowtext 1.0pt;border-top: none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:27.0pt" width="269"> NCHAR<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="291"> Maximum size: 2000 bytes 最长大小为2000字节<o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="223"> None<o:p></o:p> </td> <td style="width:257.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="343" valign="bottom" nowrap=""> Oracle NCHAR类型最大为2000字节<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:12;height:82.5pt"> <td rowspan="2" style="width:202.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: white;padding:0cm 5.4pt 0cm 5.4pt;height:82.5pt" width="269"> NCHAR VARYING<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:82.5pt" width="291"> Maximum size: 4000 bytes, or 32767 bytes if the MAX_STRING_SIZE initialization parameter is set to EXTENDED NCHAR 变量为4000 如果设置MAX_STRING_SIZE为EXTENDED,最大可支持32767个字节<o:p></o:p> </td> <td rowspan="2" style="width:167.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:82.5pt" width="223"> None<o:p></o:p> </td> <td style="width:257.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:82.5pt" width="343" valign="bottom"> Oracle NCHAR类型变量为4000 如果设置了 MAX_STRING_SIZE为EXTENDED可以为32767字节<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:13;height:40.5pt"> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:40.5pt" width="291"> <a href="http://docs.oracle.com/database/122/REFRN/MAX_STRING_SIZE.htm#GUID-D424D23B-0933-425F-BC69-9C0E6724693C">See Also: "MAX_STRING_SIZE" initialization parameter for additional details</a><o:p></o:p> </td> <td style="width:257.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:40.5pt" width="343" valign="bottom" nowrap=""> 　<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:14;height:94.5pt"> <td style="width:202.0pt;border:solid windowtext 1.0pt;border-top: none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:94.5pt" width="269"> NCLOB<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:94.5pt" width="291"> Maximum size: (4 GB - 1) * DB_BLOCK_SIZE initialization parameter (8 TB to 128 TB) 最大大小为 (4 GB - 1) * DB_BLOCK_SIZE. 根据块大小不同范围为8TB到128TB.<o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:94.5pt" width="223"> <a href="http://docs.oracle.com/database/122/REFRN/datatype-limits.htm#fnsrc_d2172132e331">The number of LOB columns per table is limited only by the maximum number of columns per table (that is, 1000Footref ). 一个表中可包含的LOB列的多少由表中最大列数量决定</a><o:p></o:p> </td> <td style="width:257.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:94.5pt" width="343" valign="bottom"> Oracle NCLOB最大大小为(4 GB - 1) 个块 根据块大小不同,最大值可为8T到128T<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:15;height:46.5pt"> <td rowspan="2" style="width:202.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: white;padding:0cm 5.4pt 0cm 5.4pt;height:46.5pt" width="269"> NUMBER<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:46.5pt" width="291">  999...(38 9's) x10125 maximum value 最大值999...(38 9's) x10125 <o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:46.5pt" width="223"> Can be represented to full 38-digit precision (the mantissa)<o:p></o:p> </td> <td style="width:257.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:46.5pt" width="343" valign="bottom" nowrap=""> 最大值为<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:16;height:46.5pt"> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:46.5pt" width="291">  999...(38 9's) x10125 maximum value 最小值-999...(38 9's) x10125<o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:46.5pt" width="223"> Can be represented to full 38-digit precision (the mantissa)<o:p></o:p> </td> <td style="width:257.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:46.5pt" width="343" valign="bottom"> 最小值为<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:17;height:13.5pt"> <td style="width:202.0pt;border:solid windowtext 1.0pt;border-top: none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:13.5pt" width="269"> Precision(精度)<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" width="291"> 38 significant digits <o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" width="223"> None<o:p></o:p> </td> <td style="width:257.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:13.5pt" width="343"> 精度为38<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:18;height:67.5pt"> <td rowspan="2" style="width:202.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: white;padding:0cm 5.4pt 0cm 5.4pt;height:67.5pt" width="269"> RAW<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:67.5pt" width="291"> Maximum size: 2000 bytes, or 32767 bytes if the MAX_STRING_SIZE initialization parameter is set to EXTENDED 最大大小为2000字节,如果设置MAX_STRING_SIZE参数为 EXTENDED则为32767<o:p></o:p> </td> <td rowspan="2" style="width:167.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:67.5pt" width="223"> None<o:p></o:p> </td> <td rowspan="2" style="width:257.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:67.5pt" width="343" valign="bottom"> Oracle RAW类型最大大小为2000字节 如果设置MAX_STRING_SIZE参数为 EXTENDED则为32767<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:19;height:40.5pt"> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:40.5pt" width="291"> <a href="http://docs.oracle.com/database/122/REFRN/MAX_STRING_SIZE.htm#GUID-D424D23B-0933-425F-BC69-9C0E6724693C">See Also: "MAX_STRING_SIZE" initialization parameter for additional details</a> <o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:20;height:27.0pt"> <td style="width:202.0pt;border:solid windowtext 1.0pt;border-top: none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt:solid windowtext .5pt; mso-border-right-alt:solid windowtext .5pt;background:white;padding:0cm 5.4pt 0cm 5.4pt; height:27.0pt" width="269"> VARCHAR<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="291"> Maximum size: 4000 bytes 最长为4000字节<o:p></o:p> </td> <td style="width:167.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="223"> None<o:p></o:p> </td> <td style="width:257.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:27.0pt" width="343" valign="bottom" nowrap=""> Oracle VARCHAR类型最长为4000字节<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:21;height:96.0pt"> <td rowspan="2" style="width:202.0pt;border:solid windowtext 1.0pt; border-top:none;mso-border-left-alt:solid windowtext .5pt;mso-border-bottom-alt: solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt;background: white;padding:0cm 5.4pt 0cm 5.4pt;height:96.0pt" width="269"> VARCHAR2<o:p></o:p> </td> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:96.0pt" width="291"> Maximum size: 4000 bytes, or 32767 bytes if the MAX_STRING_SIZE initialization parameter is set to EXTENDED 最大大小为4000字节,如果设置MAX_STRING_SIZE参数为 EXTENDED则为32767<o:p></o:p> </td> <td rowspan="2" style="width:167.0pt;border-top:none;border-left: none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:96.0pt" width="223"> None<o:p></o:p> </td> <td rowspan="2" style="width:257.0pt;border-top:none; border-left:none;border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-left-alt:solid windowtext .5pt;mso-border-left-alt:solid windowtext .5pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; padding:0cm 5.4pt 0cm 5.4pt;height:96.0pt" width="343" valign="bottom"> Oracle VARCHAR2最大大小为4000字节 如果设置MAX_STRING_SIZE参数为 EXTENDED则为32767<o:p></o:p> </td> </tr> <tr style="mso-yfti-irow:22;mso-yfti-lastrow:yes;height:40.5pt"> <td style="width:218.0pt;border-top:none;border-left:none; border-bottom:solid windowtext 1.0pt;border-right:solid windowtext 1.0pt; mso-border-bottom-alt:solid windowtext .5pt;mso-border-right-alt:solid windowtext .5pt; background:white;padding:0cm 5.4pt 0cm 5.4pt;height:40.5pt" width="291"> <a href="http://docs.oracle.com/database/122/REFRN/MAX_STRING_SIZE.htm#GUID-D424D23B-0933-425F-BC69-9C0E6724693C">See Also: "MAX_STRING_SIZE" initialization parameter for additional details</a><o:p></o:p> </td> </tr> </tbody></table>
<o:p> </o:p><o:p></o:p>
</div>

上一篇：为方便大家学习,特公布标准实验环境|下一篇：Oracle 脚本-查看临时段使用信息