This article is used to gather data type differences information for people who are porting SQL from SQL Server to Oracle or vise versa.
The differences are list in the following table. If you have more to put into, please leave a comment here and we will include it in the table.
SQL Server | Oracle |
---|---|
INTEGER | NUMBER(10) |
SMALLINT | NUMBER(6) |
TINYINT | NUMBER(3) |
REAL | FLOAT |
FLOAT | FLOAT |
BIT | NUMBER(1) |
VARCHAR(n) | VARCHAR2(n) |
TEXT | CLOB |
IMAGE | BLOB |
BINARY(n) | RAW(n) or BLOB |
VARBINARY | RAW(n) or BLOB |
DATETIME | DATE |
SMALL-DATETIME | DATE |
MONEY | NUMBER(19,4) |
NCHAR(n) | CHAR(n*2) |
NVARCHAR(n) | VARCHAR(n*2) |
SMALLMONEY | NUMBER(10,4) |
TIMESTAMP | NUMBER |
SYSNAME | VARCHAR2(30), VARCHAR2(128) |