Oracle Data Types

Data Type	Description
VARCHAR2(size)	Variable-length character data
CHAR(size)	Fixed-length character data
NUMBER(p,s)	Variable-length numeric data
DATE	Date and time values
LONG	Variable-length character data(up to 2G);Oracle推荐不使用此数据类型,推荐使用CLOB、BLOB
CLOB	Character data(up to 4GB)
RAW and LONG RAW	Raw binary data
BLOB	Binary data(up to 4GB)
BFILE	Binary data stored in an external file(up to 4GB)
ROWID	A base-64 number system representing the unique address of a row in  its table.

 

 

 

 

 

 

 

 

 

 

 

 

Data Type	Description
TIMESTAMP	Date with fractional seconds
INTERVAL YEAR TO MONTH	Stored as an interval of years and moths
INTERVAL DAY TO SECOND	Stored as an interval days,hours,mintues,and seconds