Translation_oracle_DataType

_ 下划线代表翻译辞

(%) %代表用翻译下划线的英文

此颜色代表单词组

此颜色上文已翻译

Table 3-1Built-inData(内置数据)TypeSummary(总结)

Code	Data Type	Description(描述)
1	VARCHAR2(size[BYTE|CHAR])	Variable-length(可变的长)character string having maximum lengthsizebytes or characters. Maximumsizeis 4000 bytes or characters, and minimum is 1 byte or 1 character. You mustspecify(指定)sizeforVARCHAR2. BYTEindicates that the column will have byte length semantics.CHARindicates that the column will have character semantics.
1	NVARCHAR2(size)	Variable-length Unicode character string having maximum lengthsizecharacters. The number of bytes can be up to two timessizeforAL16UTF16encoding(编码)and three timessizeforUTF8encoding. Maximumsizeisdetermined(决定)by the national character setdefinition(定义), with anupper limit(限制)of 4000 bytes. You mustspecifysizeforNVARCHAR2.
2	NUMBER[ (p[,s]) ]	Number havingprecision(精确度)pandscale(小数)s. The precisionpcan range from 1 to 38. The scalescan range from -84 to 127.Bothprecisionandscale are indecimal digits(十进制小数). ANUMBERvaluerequires(规定)from 1 to 22 bytes.
2	FLOAT[(p)]	A subtype of theNUMBERdatatype having precisionp. AFLOATvalue isrepresented(代表)internally(内部)asNUMBER. The precisionpcan range from 1 to 126binary digits(二进制). AFLOATvaluerequiresfrom 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_FORMATparameter(参数)orimplicitly(绝对的)by theNLS_TERRITORYparameter. 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_precisionis the number ofdigits(数字)in the fractional part of theSECOND(次要)datetimefield.Accepted(公认的)values offractional_seconds_precisionare 0 to 9. The default is 6. The default format isdetermined explicitlyby theNLS_TIMESTAMP_FORMATparameterorimplicitly(绝对的)by theNLS_TERRITORYparameter. 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)]WITHTIMEZONE	All values ofTIMESTAMPas well as time zonedisplacement(替代)value, wherefractional_seconds_precisionis the number ofdigitsinthefractionalpart oftheSECONDdatetime field.Acceptedvalues are 0 to 9. The default is 6. The default format isdetermined explicitlyby theNLS_TIMESTAMP_FORMATparameter or implicitly by theNLS_TERRITORYparameter. 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)]WITHLOCALTIMEZONE	All values ofTIMESTAMPWITHTIMEZONE, 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_FORMATparameter or implicitly by theNLS_TERRITORYparameter. The size is 7 or 11 bytes, depending on theprecision(精度).
182	INTERVALYEAR[(year_precision)]TOMONTH	Stores(储存)aperiod(阶段)of time in years and months, whereyear_precisionisthe number of digits(位数)in theYEARdatetime field.Accepted(公认的)values are 0 to 9. The default is 2. The size is fixed at 5 bytes.
183	INTERVALDAY[(day_precision)]TOSECOND[(fractional_seconds)]	Stores a period oftime in days, hours, minutes, and seconds, where day_precisionis the maximum number of digits in theDAYdatetime field. Accepted values are 0 to 9. The default is 2. fractional_seconds_precisionis the number of digits in the fractional part of theSECONDfield. Accepted values are 0 to 9. The default is 6. The size is fixed at 11 bytes.
23	RAW(size)	Raw(最初的)binary data of lengthsizebytes. Maximumsizeis 2000 bytes. You must specifysizefor aRAWvalue.
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 theROWIDpseudocolumn.
208	UROWID[(size)]	Base 64 stringrepresentingthelogical(逻辑)address of a row of an index-organized table. The optionalsizeisthe size of(..大小)a column of typeUROWID. The maximum size and default is 4000 bytes.
96	CHAR[(size[BYTE|CHAR])]	Fixed(固定)-length character data of lengthsizebytes or characters. Maximumsizeis 2000 bytes or characters. Default and minimumsizeis 1 byte. BYTEandCHARhavethe samesemantics(语法)asforVARCHAR2.
96	NCHAR[(size)]	Fixed-length character data of lengthsizecharacters.The number of(..的数量)bytes can be up to two timessizeforAL16UTF16encoding and three timessizeforUTF8encoding. Maximumsizeisdetermined(决定)by the national character setdefinition(定义), with an upper limit of 2000 bytes. Default and minimumsizeis 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.