SAP HANA Source Data Type | Oracle Target Data Type |
|---|---|
alphanum(precision), 1 <= p <= 127 | varchar2(s char), 1 <= s <= 127 |
array | blob |
bigint | number(19) |
binary(size), 1 <= size <= 2000 | raw(size), 1 <= size <= 2000 |
boolean | char(1 char) |
char(size), 1 <= size <= 2000 | varchar2(s byte), 1 <= s <= 2000 |
date | date |
decimal | char(255 char) |
decimal(p,s), 1 <= p <= 38, 0 <= s <= 38 | number(p,s), 1 <= p <= 38, 0 <= s <= 38 |
double | binary_double |
float | binary_double |
integer | number(10) |
nchar(size), 1 <= size <= 1000 | nvarchar2(s char), 1 <= s <= 1000 |
nchar(size), 1001 <= size <= 2000 | char(2000 char) |
nvarchar(size), 1 <= size <= 901 | nvarchar2(s char), 1 <= s <= 901 |
nvarchar(size), 1001 <= size <= 1901 | char(2000 char) |
nvarchar(size), 2001 <= size <= 5000 | clob |
real | binary_float |
real | binary_float |
seconddate | date |
shorttext(precision), 1 <= p <= 3901 | varchar2(s char), 1 <= s <= 3901 |
shorttext(precision), 4001 <= p <= 5000 | clob |
smalldecimal | char(255 char) |
smallint | number(5) |
st_geometry | blob |
st_point | blob |
time | timestamp(0) |
timestamp | date |
timestamp | timestamp(precision), 1 <= p <= 7 |
tinyint | number(3) |
varbinary(size), 1 <= size <= 1501 | raw(size), 1 <= size <= 1501 |
varchar(size), 1 <= size <= 3901 | varchar2(s byte), 1 <= s <= 3901 |
varchar(size), 4001 <= size <= 5000 | clob |