Client Data Types | Oracle Data Types |
|---|---|
BIGINT | NUMBER(19,0) |
BYTE VARYING(n) | Not supported |
BYTE(n)* | Not supported |
C | Not supported |
CHAR(n) Note: CHARACTER(n) is a synonym for CHAR(n). | CHAR(n) Note: The length specifier (n) is required in DDL statements. |
DATE | DATE |
DECIMAL(p,s)* | NUMBER(p,s)* Note: If the money mapping of MONEY is selected, all data declared as NUMBER(19,4) is returned as money. |
FLOAT | FLOAT(126) |
FLOAT4 | FLOAT(63) |
FLOAT8 | FLOAT(126) |
INTEGER | INTEGER |
INTEGER1 | NUMBER (3,0) |
INTEGER2 | NUMBER(5,0) |
INTEGER4 | NUMBER(10,0) Note: The range for zero scale numbers above a certain precision no longer maps to INTEGER. The range has been reduced; BIGINT is now used for large precision and zero scale. For more information, see Oracle NUMBER Mapping. |
LONG BYTE* | BLOB The LONG RAW data type is no longer supported. |
LONG NVARCHAR | Not supported |
LONG VARCHAR* | CLOB The LONG data type is no longer supported. |
MONEY | FLOAT-Default money data type mapping NUMBER(19,4)-Money data type mapping If you select the money mapping NUMBER(19, 4) for Oracle, all data declared as NUMBER (19, 4) is returned as money. |
NCHAR(n) | NCHAR(n)-Maximum size of n is 1000. Storage size is two times n bytes. Note: The length specifier (n) is required in DDL statements. |
NVARCHAR(n) | NVARCHAR2(n)-Maximum size of n is 2000. Storage size is two times n bytes. Note: The length specifier (n) is required in DDL statements. |
REAL | FLOAT(63) |
SMALLINT | NUMBER(5,0) |
TEXT | Not supported |
VARCHAR(n) | VARCHAR(n) Note: The length specifier (n) is required in DDL statements. |