| BYTE |
RAW |
- |
| BYTE VARYING |
RAW |
- |
| C, CHAR |
CHAR |
- |
| DATE |
DATE |
DATE range is January 1, 1582 through December 31, 2382. |
| DECIMAL |
NUMBER(p[,s]) |
If precision and scale are not specified, DECIMAL is converted to NUMBER(16) |
| FLOAT |
FLOAT(49) |
- |
| FLOAT4 |
FLOAT(23) |
- |
| FLOAT8 |
FLOAT(49) |
- |
| INTEGER |
NUMBER(10) |
NUMBER range is -2,147,483,647 to 2,147,483,647 |
| INTEGER1 |
NUMBER(3) |
- |
| INTEGER2 |
NUMBER(5) |
NUMBER range is -32,767 to 32,767 |
| INTEGER4 |
NUMBER(10) |
NUMBER range is -2,147,483,647 to 2,147,483,647 |
| LONG BYTE |
LONG RAW |
- |
| LONG VARCHAR |
LONG |
- |
| MONEY |
FLOAT(49) |
- |
| OBJECT_KEY |
CHAR(16) |
- |
| SMALLINT |
NUMBER(5) |
NUMBER range is -32,767 to 32,767 |
| TABLE_KEY |
CHAR(8) |
- |
| TEXT |
VARCHAR2 |
The length of a TEXT data type ranges from 1 to 2000 characters |
| VARCHAR |
VARCHAR2 |
The length of a VARCHAR data type ranges from 1 to 2000 characters |
