|
PL/SQL Datatype T-SQL Datatype
NUMBER or DECIMAL DECIMAL or NUMERIC
FLOAT FLOAT
REAL REAL
NUMBER MONEY, SMALLMONEY
LONG DECIMAL or NUMERIC
INTEGER, BINARY_ INTEGER, PLS_ INTEGER INTEGER
SMALLINT SMALLINT
NUMBER or DECIMAL TINYINT
DOUBLE PRECISION DOUBLE PRECISION
NATURAL DECIMAL or NUMERIC
NATURALN DECIMAL or NUMERIC
POSITIVE DECIMAL or NUMERIC
POSITIVEN DECIMAL or NUMERIC
CHAR, CHARACTER CHAR, CHARACTER
VARCHAR, STRING VARCHAR
VARCHAR2 VARCHAR
RAW, LONG RAW TEXT, IMAGE
DATE DATETIME, SMALLDATETIME
BOOLEAN BIT
ROWID TIMESTAMP
|