Char fixed length character fields, up to 2 000 bytes
The fixed-length character field of the nchar multi-byte character set. The length varies with the character set. It can contain a maximum of or characters.
Varchar2 can contain up to characters
The variable-length character field of the nvarchar2 multi-byte character set. The length varies with the character set. It can contain a maximum of or characters.
Date is used to store the fixed-length (7 bytes) character fields of all dates. Time is stored as part of the date. Unless you replace the date format by setting the nls_date_format parameter of the init. ora file, the date is expressed in DD-MON-YY format during a query, for example, 13-apr-99 represents
Number Variable Length Value column. The allowed values are 0, positive, and negative. The number value is usually stored in four or fewer bytes.
Long Variable Length character field, maximum length can be 2 GB
Raw indicates the variable-length character field of binary data, up to 2 000 bytes
Long raw indicates the variable-length character field of binary data. The maximum length is 2 GB.
Mlslabel is only used for trusted oracle. This data type uses 2 to 5 bytes per row.
Blob Binary large object with a maximum length of 4 GB
Clob character large object with a maximum length of 4 GB
The clob Data Type of the nclob multi-byte character set. The maximum length is 4 GB.
Bfile external binary file, size determined by the operating system
Rowid indicates the binary data of rowid. The value of Oracle 8 rowid is 1 0 bytes,
Urowid is the binary data used for data addressing. The maximum length is bytes.
Http://blog.csdn.net/onlysql/archive/2006/03/28/642051.aspx:
