SQL Server/T-SQL Tutorial/Data Types/Data type

Материал из SQL эксперт
Перейти к: навигация, поиск

Datatype equivalents from PL/SQL to T-SQL.

   <source lang="sql">

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</source>