Datatype Mapping From SQL Server to Oracle

The following section lists datatype mapping from SQL Server to Oracle.

bigint=NUMBERbinary=LONGbit=NUMBERchar=VARCHAR2datetime=DATEdecimal=NUMBERfloat=FLOATimage=LONGint=NUMBERmoney=NUMBERnchar=VARCHAR2ntext=NVARCHAR2numeric=NUMBERnvarchar=VARCHAR2real=FLOATsmallint=NUMBERsmalldatetime=DATEsmallmoney=NUMBERsql_variant=LONGsysname=CHARtext=LONGtinyint=NUMBERvarbinary=NVARCHAR2

iWay Software