Ispirer Website
Ispirer Capabilities - Oracle Migration
Free Trial
Oracle - Data Types
Versions: Oracle 11g, 10g, 9i, 8i and 7.3
| Data Type | Parameters and Range |
|---|---|
| Character Data Types | |
| CHAR(n) - Fixed-length character data | 1 ⇐ n ⇐ 2000/charsize, default is 1 |
| NCHAR(n) - Fixed-length character data in Unicode | 1 ⇐ n ⇐ 2000/charsize, default is 1 |
| VARCHAR2(n) - Variable-length character data | 1 ⇐ n ⇐ 4000/charsize, n is mandatory |
| NVARCHAR2(n) - Variable-length character data in Unicode | 1 ⇐ n ⇐ 4000/charsize, n is mandatory |
| CLOB - Variable-length character data (large object) | 4G |
| NCLOB - Variable-length character data in Unicode (large object) | 4G |
| LONG - Variable-length character data | 2G, backward compatibility - not recommended for use |
| Numeric Data Types | |
| NUMBER(p,s) - Integer, decimal and floating-point numeric data | 1 ⇐ p ⇐ 38, default is 38; -84 ⇐ s ⇐ 127, default is 0 |
| FLOAT(p) - Floating-point numeric data | 1 ⇐ p ⇐ 126, default is 126 |
| BINARY_FLOAT - Floating-point numeric data | 1.17E-38 to 3.40E+38, special values: INF and NaN |
| BINARY_DOUBLE - Floating-point numeric data | 2.22E-308 to 1.79E+308, special values: INF and NaN |
| Date and Time Data Types | |
| DATE - Date and time data (day, month, year, hours, minutes and seconds) | January 1, 4712 BC 00:00:00 to December 31, 9999 23:59:59 |
| TIMESTAMP(p) - Date and time data (day, month, year, hours, minutes, seconds and fractional seconds) | January 1, 4712 BC 00:00:00.0(9) to December 31, 9999 23:59:59.0(9) 0 ⇐ p ⇐ 9, default is 6 (microseconds) |
| INTERVAL YEAR(p) TO MONTH - Period of time in years and months | 0 ⇐ p ⇐ 9, default is 2 |
| INTERVAL DAY(p1) TO SECOND(p2) - Period of time in days, hours, minutes, seconds and fractional seconds | 0 ⇐ p1 ⇐ 9, default is 2 ; 0 ⇐ p2 ⇐ 9 , default is 6 |
| Binary Data Types | |
| RAW(n) - Variable-length binary data | 1 ⇐ n ⇐ 2000 |
| LONG RAW - Variable-length binary data | 2G, not recommended for use |
| BLOB - Variable-length binary data (binary large object) | 4G |
| Other Data Types | |
| BFILE - Pointer to binary file | 264 - 1 bytes |
| ROWID - Physical row address | Data returned by rowid pseudocolumn |
| UROWID(p) - Logical row addresses | 1 ⇐ p ⇐ 4000, default is 4000 |
Data Types in Other Databases