KS DB Merge Tools logo KS DB Merge Tools
Documentation
KS DB Merge Tools for Cross-DBMS logo for Cross-DBMS
 
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
AccdbMerge logo

Oracle data types

Here is a data type mapping from Oracle native data types to application generic data types. Any data type not listed in this table is mapped to Other generic data type.

Native data typeGeneric data type
BINARY_DOUBLENumber
BINARY_FLOATNumber
BLOBBinary
CHARString
CLOBString
DATEDateTime
FLOATNumber
LONGString
LONG RAWBinary
NCHARString
NCLOBString
NUMBERNumber
NVARCHAR2String
RAWBinary
TIMESTAMPDateTime
TIMESTAMP WITH LOCAL TIME ZONEDateTime
TIMESTAMP WITH TIME ZONEDateTime
VARCHAR2String

Last updated: 2023-10-10