本文共 6643 字,大约阅读时间需要 22 分钟。
The table that follows summarizes 总结 Oracle built-in data types. Refer to the syntax in the preceding sections for the syntactic elements. The codes代码 listed for the data types are used internally by Oracle Database. The data type code of a column or object attribute is returned by the DUMP
function.
Table 3-1 Built-in Data Type Summary
Code | Data Type | Description |
---|---|---|
1 |
| length
|
1 |
| Variable-length Unicode character string having maximum length |
2 |
| Number having precision精度 |
2 |
| A subtype图表类型 of the |
8 |
| Character data of variable length up to 2 gigabytes, or 231 -1 bytes. Provided提供 for backwardcompatibility兼容性. |
12 |
| Valid有效 date range from January 1, 4712BC , to December 31, 9999 AD. The default format isdetermined explicitly确定明确 by the |
21 |
| 32-bit floating point浮点 number. This data typerequires需要 4 bytes. |
22 |
| 64-bit floating point number. This data type requires 8 bytes. |
180 |
| Year, month, and day values of date, as well as以及 hour, minute, and second values of time, where |
181 |
| All values of |
231 |
| All values of
The default format is determined explicitly明确确定 by the |
182 |
| Stores a period of time一段时间 in years and months, where |
183 |
| Stores a period of time in days, hours, minutes, and seconds, where
The size is fixed固定at 11 bytes. |
23 |
| Raw binary原二进制 data of length |
24 |
| Raw binary原二进制 data of variable length up to 2 gigabytes. |
69 |
| Base 64 string representing代表 the unique address of a row in its table. This data type is primarily for values returned by the |
208 |
| Base 64 string representing代表the logical address of a row of an index-organized table. The optional可选项 |
96 |
| Fixed-length character data of length
|
96 |
| Fixed-length character data of length |
112 |
| A character large object containing single-byte ormultibyte多字符 characters. Both fixed-width and variable-width character sets are supported被支持, both using the database character set. Maximum size is (4 gigabytes - 1) * (database block size). |
112 |
| A character large object containing包含 Unicode characters. Both fixed-width and variable-width character sets are supported, both using the database national character set. Maximum size is (4 gigabytes - 1) * (database block size). Stores national character set data.最大为4G字节 |
113 |
| A binary二进制 large大 object. Maximum size is (4 gigabytes - 1) * (database block size). |
114 |
| Contains包含 a locator定位器 to a large binary file stored存储 outside除啦 the database.Enables实现 byte stream字节 I/O access使用 toexternal外部 LOBs residing on居住 the database server. Maximum size is 4 gigabytes. |
转载地址:http://xhzli.baihongyu.com/