Find below default mapping from
supported ORACLE data types to HANA DATA types:
ORACLE
|
HANA
|
|
CHAR
|
NVARCHAR
|
|
VARCHAR2
|
NVARCHAR
|
|
NVARCHAR2
|
NVARCHAR
|
|
NCHAR
|
NVARCHAR
|
|
DATE
|
NVARCHAR(8)
|
|
TIMESTAMP
|
NVARCHAR (40)
|
|
NUMBER (p=0 or p>31, s=0)
*p - precision *s - scale |
DOUBLE
|
|
NUMBER (0<p<=4, s=0)
|
SMALLINT
|
|
NUMBER (4<p<=9, s=0)
|
INTEGER
|
|
NUMBER (9<p<=31, s=0)
|
DECIMAL
|
|
NUMBER (p<=31, 0<s<=14)
|
DECIMAL
|
|
NUMBER(all others)
|
DOUBLE
|
|
FLOAT
|
DOUBLE
|
• I very much enjoyed this article. Nice article thanks for given this information. I hope it useful to many People DATA SINCE Online Training
ReplyDelete