| Data type | Length | Description |
|---|---|---|
| VARCHAR2(size) | 1 - 4000 bytes | Text string of variable length. It is necessary to define maximum number of characters. |
| NVARCHAR2(size) | 1 - 4000 bytes | Text string of Unicode characters of variable length. It is necessary to define maximum number of characters. |
| VARCHAR | - | Obsolete (used for backward compatibility only). VARCHAR is a synonym for VARCHAR2 type but the usage may change in future versions. |
| CHAR(size) | 1 - 2000 bytes | Text string of fixed length. It is necessary to define maximum number of characters (default 1). |
| NCHAR(size) | 1 - 2000 bytes | Text string of Unicode characters of fixed length. It is necessary to define maximum number of characters (default 1). |
| NUMBER(p,s) | The precision p can range from 1 to 38. The scale s can range from -84 to 127. | Number with the precision p and with scale s. |
| DATE | from January 1, 4712 BC to December 31, 9999 AD. | Date with the precision of 1 second. |
| TIMESTAMP (fractional_seconds_precision) | Accepted values of fractional_seconds_precision are 0 to 9. (default = 6) | Date with the precision of fractions seconds. The precision can be entered as a number of decimal places of second. |
| TIMESTAMP (fractional_seconds_precision) WITH {LOCAL} TIMEZONE | Accepted values of fractional_seconds_precision are 0 to 9. (default = 6) | As TIMESTAMP, but with time zone definition. |
| INTERVAL YEAR (year_precision) TO MONTH | Accepted values are 0 to 9. (default = 2) | Time in years and months, where year_precision is the number of digits in the "YEAR" datetime field. |
| INTERVAL DAY (day_precision) TO SECOND (fractional_seconds_precision) | day_precision may be 0 to 9. (default = 2) fractional_seconds_precision may be 0 to 9. (default = 6) | Time in days, in hours, in minutes and in seconds.
day_precision = maximum number of digits in "DAY". fractional_seconds_precision = maximum number of decimal places in the SECOND field. |
| RAW(size) | 1 - 2000 bytes | Raw binary data of length size in bytes. You must specify size for a RAW value. |
| ROWID | 10 bytes | Hexadecimal string - represents the unique address of the table row (primarily for values returned by the ROWID pseudocolumn). |
| UROWID | The maximum size and default is 4000 bytes | Hexadecimal string - represents the logical row address of an index-organized table |
| MLSLABEL | - | Binary format of an operating system label. This data type is used with Trusted Oracle7. |
| CLOB | 8 - 128 TB (4 Gigabytes - 1) * (database block size) | Large string of characters stored in Large Object. |
| NCLOB | 8 - 128 TB (4 Gigabytes - 1) * (database block size) | Large string of Unicode characters in Large Object. |
| BLOB | 8 - 128 TB (4 Gigabytes - 1) * (database block size) | Binary Large Object. |
| BFILE | 8 - 128 TB (4 Gigabytes - 1) * (database block size) | Pointer to binary disk file |
| XMLType | 4 Gigabytes | XML data. |