【2017年整理】ORACLE数据类型说明.docVIP

字段类型中文说明限制条件其它说明ORACLE数据类型说明oracle数据类型列表及说明Built-In Datatype Summary Codea Built-In Datatype Description 1 VARCHAR2(size) [BYTE | CHAR] Variable-length character string having maximum length size bytes or characters. Maximum size is 4000 bytes, and minimum is 1 byte or 1 character. You must specify size for VARCHAR2. BYTE indicates that the column will have byte length semantics; CHAR indicates that the column will have character semantics. 1 NVARCHAR2(size) Variable-length character string having maximum length size characters. Maximum size is determined by the national character set definition, with an upper limit of 4000 bytes. You must specify size for NVARCHAR2. 2 NUMBER(p,s) Number having precision p and scale s. The precision p can range from 1 to 38. The scale s can range from -84 to 127. 8 LONG Character data of variable length up to 2 gigabytes, or 231 -1 bytes. 12 DATE Valid date range from January 1, 4712 BC to December 31, 9999 AD. 180 TIMESTAMP (fractional_seconds_precision) Year, month, and day values of date, as well as hour, minute, and second values of time, where fractional_seconds_precision is the number of digits in the fractional part of the SECOND datetime field. Accepted values of fractional_seconds_precision are 0 to 9. The default is 6. 181 TIMESTAMP (fractional_seconds_precision) WITH TIME ZONE All values of TIMESTAMP as well as time zone displacement value, where fractional_seconds_precision is the number of digits in the fractional part of the SECOND datetime field. Accepted values are 0 to 9. The default is 6. 231 TIMESTAMP (fractional_seconds_precision) WITH LOCAL TIME ZONE All values of TIMESTAMP WITH TIME ZONE, with the following exceptions: Data is normalized to the database time zone when it is stored in the database. When the data is retrieved, users see the data in the session time zone. 182 INTERVAL YEAR (year_precision) TO MONTH Stores a period of time in years and months, where year_precision is the number of digit