| Datatype
| Description
|
| Char
| A fixed length character field, up to 2,000 bytes in length.
|
| Nchar
| A fixed length field for multibyte character sets. Max size is 2000 characters or 2000 bytes, depending on the characterset.
|
| varchar2
| A variable lenght character field, up to 4000 characters in length.
|
| nvarchar2
| A variable length fiedl for multibyte character sets. Max size is 4000 characters or 4000 bytes depending on the characterset.
|
| date
| A fixed lenght 7 byte field used to store dates. Displayed date format can be overridden with the NLS_DATE_FORMAT parameter.
|
| number
| A variable length number column. Provides facility for Precision and scale number(9,2) specifies a floating point number nine digits long, two of which are to the right of the decimal point.
|
| long
| A variable length field up to 2 gigs in length.
|
| raw
| A variable length field used for binary data up to 2,000 bytes in length.
|
| long raw
| A variable length field used for binary data up to 2 gigs in length.
|
| mlslabel
| For trusted Oracle only; this data type uses between 2 and 5 bytes per row.
|
| blob
| Binary large object - up to four gigs long.
|
| clob
| Character large object - up to four gigs long
|
| nclob
| Clob datatype for multibyte character sets up to four gigs long.
|
| bfile
| External binary file; size limit is os dependent.
|
| rowid
| Binary data representing a rowid. Value will be 1 bytes for Oracle 8 rowid values; 6 bytes for restricted rowid format used in Oracle 7.
|
| urowid
| Binary data used for data addressing up to 4,000 bytes in length.
|