Oracle Built-in Data Type Matching
Oracle Datatype |
XFM Datatype |
---|---|
VARCHAR2(size [BYTE | CHAR]) |
String |
NVARCHAR2(size) |
String |
NUMBER[(precision [, scale]]) |
Double |
LONG |
NOT MODELED |
DATE |
Date |
BINARY_FLOAT |
NOT MODELED |
BINARY_DOUBLE |
NOT MODELED |
TIMESTAMP [(fractional_seconds)] |
NOT MODELED |
TIMESTAMP [(fractional_seconds)] WITH TIME ZONE |
NOT MODELED |
TIMESTAMP [(fractional_seconds)] WITH LOCAL TIME ZONE |
NOT MODELED |
INTERVAL YEAR [(year_precision)] TO MONTH |
NOT MODELED |
INTERVAL DAY [(day_precision)] TO SECOND [(fractional_seconds)] |
NOT MODELED |
RAW(size) |
NOT MODELED |
LONG RAW |
NOT MODELED |
ROWID |
NOT MODELED |
UROWID [(size)] |
NOT MODELED |
CHAR [(size [BYTE | CHAR])] |
String |
NCHAR[(size)] |
String |
CLOB |
NOT MODELED |
NCLOB |
NOT MODELED |
BLOB |
NOT MODELED |
BFILE |
NOT MODELED |