SQL Server data Types |
Oracle data Types |
bigint |
Number (19,0) |
Binary (1-2000) |
RAW (1-2000) |
Binary (2001-8000) |
Blob |
Bit |
Number (1) |
char (1-2000) |
CHAR (1-2000) |
char (2001-4000) |
VARCHAR2 (2001-4000) |
char (4001-8000) |
Clob |
Date |
DATE |
Datetime |
DATE |
DateTime2 (0-7) |
TIMESTAMP (7) (for Oracle 9 and Oracle); VARCHAR (27) (for Oracle 8) |
DateTimeOffset (0-7) |
TIMESTAMP (7) with time ZONE (for Oracle 9 and Oracle); VARCHAR (34) (for Oracle 8) |
Decimal (1-38, 0-38) |
Number (1-38, 0-38) |
Float (53) |
FLOAT |
Float |
FLOAT |
Geographical |
Blob |
Geometry |
Blob |
HierarchyID |
Blob |
Image |
Blob |
Int |
Number (10,0) |
Money |
Number (19,4) |
NCHAR (1-1000) |
CHAR (1-1000) |
NCHAR (1001-4000) |
NCLOB |
ntext |
NCLOB |
Numeric (1-38, 0-38) |
Number (1-38, 0-38) |
nvarchar (1-1000) |
VARCHAR2 (1-2000) |
nvarchar (1001-4000) |
NCLOB |
nvarchar (max) |
NCLOB |
Real |
Real |
smalldatetime |
DATE |
Int |
Number (5,0) |
SmallMoney |
Number (10,4) |
sql_variant |
N/A |
sysname |
VARCHAR2 (128) |
Text |
Clob |
Time (0-7) |
VARCHAR (16) |
Timestamp |
RAW (8) |
tinyint |
Number (3,0) |
uniqueidentifier |
CHAR (38) |
varbinary (1-2000) |
RAW (1-2000) |
varbinary (2001-8000) |
Blob |
varchar (1-4000) |
VARCHAR2 (1-4000) |
varchar (4001-8000) |
Clob |
varbinary (max) |
Blob |
varchar (max) |
Clob |
Xml |
NCLOB |
Oracle and SQL Server data types correspond