1 | VARCHAR2 (size [BYTE |CHAR ]) | Variable-length(可变的长)character string having maximum lengthsize bytes or characters. Maximumsize is 4000 bytes or characters, and minimum is 1 byte or 1 character. You mustspecify(指定)size forVARCHAR2 . BYTE indicates that the column will have byte length semantics.CHAR indicates that the column will have character semantics. |
1 | NVARCHAR2 (size ) | Variable-length Unicode character string having maximum lengthsize characters. The number of bytes can be up to two timessize forAL16UTF16 encoding(编码)and three timessize forUTF8 encoding. Maximumsize isdetermined(决定)by the national character setdefinition(定义), with anupper limit(限制)of 4000 bytes. You mustspecifysize forNVARCHAR2 . |
2 | NUMBER [ (p [,s ]) ] | Number havingprecision(精确度)p andscale(小数)s . The precisionp can range from 1 to 38. The scales can range from -84 to 127.Bothprecisionandscale are indecimal digits(十进制小数). ANUMBER valuerequires(规定)from 1 to 22 bytes. |
2 | FLOAT [(p )] | A subtype of theNUMBER datatype having precisionp . AFLOAT value isrepresented(代表)internally(内部)asNUMBER . The precisionp can range from 1 to 126binary digits(二进制). AFLOAT valuerequiresfrom 1 to 22 bytes. |
8 | LONG | Character data of variable length up to 2 gigabytes, or 231-1 bytes. Provided for backwardcompatibility(兼容). |
12 | DATE | Valid(有效的)date range from January 1, 4712 BC, to December 31, 9999 AD. The default format isdetermined(决定)explicitly(明确)by theNLS_DATE_FORMAT parameter(参数)orimplicitly(绝对的)by theNLS_TERRITORY parameter. The size isfixed(固定)at 7 bytes. This data typecontains(包含)the datetimefields(字段)YEAR ,MONTH ,DAY ,HOUR ,MINUTE , andSECOND . It does not havefractional seconds(分数秒)or a timezone(时区). |
21 | BINARY_FLOAT | 32-bit floating point number. This data type requires 4 bytes. |
22 | BINARY_DOUBLE | 64-bit floating point number. This data type requires 8 bytes. |
180 | TIMESTAMP [(fractional_seconds_precision )] | Year, month, and day values of date, as well as hour, minute, and second values of time, wherefractional_seconds_precision is the number ofdigits(数字)in the fractional part of theSECOND(次要) datetimefield.Accepted(公认的)values offractional_seconds_precision are 0 to 9. The default is 6. The default format isdetermined explicitlyby theNLS_TIMESTAMP_FORMAT parameterorimplicitly(绝对的)by theNLS_TERRITORY parameter. The size is 7 or 11 bytes,depending(依赖)on theprecision(精度). This data typecontains(包含)the datetime fieldsYEAR ,MONTH ,DAY ,HOUR ,MINUTE , andSECOND . Itcontainsfractional(包含)seconds but does not have a time zone. |
181 | TIMESTAMP [(fractional_seconds )]WITH TIME ZONE | All values ofTIMESTAMP as well as time zonedisplacement(替代)value, wherefractional_seconds_precision is the number ofdigitsinthefractionalpart oftheSECOND datetime field.Acceptedvalues are 0 to 9. The default is 6. The default format isdetermined explicitlyby theNLS_TIMESTAMP_FORMAT parameter or implicitly by theNLS_TERRITORY parameter. The size isfixed(固定)at 13 bytes. This data typecontainsthe datetime fieldsYEAR ,MONTH ,DAY ,HOUR ,MINUTE ,SECOND ,TIMEZONE_HOUR , andTIMEZONE_MINUTE . It has fractional seconds and an explicit time zone. |
231 | TIMESTAMP [(fractional_seconds )]WITH LOCAL TIME ZONE | All values ofTIMESTAMP WITH TIME ZONE , with the following exceptions:
-
Data isnormalized(规范的)to the database time zone when it is stored in the database. -
When the data isretrieved(检查), users see the data in the session time zone.
The default format isdetermined explicitlyby theNLS_TIMESTAMP_FORMAT parameter or implicitly by theNLS_TERRITORY parameter. The size is 7 or 11 bytes, depending on theprecision(精度). |
182 | INTERVAL YEAR [(year_precision )]TO MONTH | Stores(储存)aperiod(阶段)of time in years and months, whereyear_precision isthe number of digits(位数)in theYEAR datetime field.Accepted(公认的)values are 0 to 9. The default is 2. The size is fixed at 5 bytes. |
183 | INTERVAL DAY [(day_precision )]TO SECOND [(fractional_seconds )] | Stores a period oftime in days, hours, minutes, and seconds, where
-
day_precision is the maximum number of digits in theDAY datetime field. Accepted values are 0 to 9. The default is 2. -
fractional_seconds_precision is the number of digits in the fractional part of theSECOND field. Accepted values are 0 to 9. The default is 6.
The size is fixed at 11 bytes. |
23 | RAW (size ) | Raw(最初的)binary data of lengthsize bytes. Maximumsize is 2000 bytes. You must specifysize for aRAW value. |
24 | LONG RAW | Raw binary data of variable length up to 2 gigabytes. |
69 | ROWID | Base 64 stringrepresenting(代表)the unique address of a row in itstable(地址). This data type isprimarily(主要的)for values returned by theROWID pseudocolumn. |
208 | UROWID [(size )] | Base 64 stringrepresentingthelogical(逻辑)address of a row of an index-organized table. The optionalsize isthe size of(..大小)a column of typeUROWID . The maximum size and default is 4000 bytes. |
96 | CHAR [(size [BYTE |CHAR ])] | Fixed(固定)-length character data of lengthsize bytes or characters. Maximumsize is 2000 bytes or characters. Default and minimumsize is 1 byte. BYTE andCHAR havethe samesemantics(语法)asforVARCHAR2 . |
96 | NCHAR [(size )] | Fixed-length character data of lengthsize characters.The number of(..的数量)bytes can be up to two timessize forAL16UTF16 encoding and three timessize forUTF8 encoding. Maximumsize isdetermined(决定)by the national character setdefinition(定义), with an upper limit of 2000 bytes. Default and minimumsize is 1 character. |
112 | CLOB | A character large object containingsingle(单)-byte ormultibyte(多字节)characters. Bothfixed-width andvariable(变化的)-widthcharacter sets(字符集)aresupported(支持的), both using the database character set. Maximum size is (4 gigabytes - 1) * (database block size). |
112 | NCLOB | A character large objectcontainingUnicode characters. Both fixed-width and variable-width character sets aresupported, both using the databasenationalcharacter set. Maximum size is (4 gigabytes - 1) * (databaseblock(块)size). Stores nationalcharacter setdata. |
113 | BLOB | A binary large object. Maximum size is (4 gigabytes - 1) * (database block size). |
114 | BFILE | Contains alocator(位置)to alarge(多数的)binary filestored(存信息的)outside the database.Enables(使..)bytestream(流)I/O access toexternal(外部的)LOBs residing on the database server. Maximum size is 4 gigabytes. |