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 |