SQLservervsOracleDatatypes.docVIP

Microsoft SQL Server Description Oracle Description INTEGER Four-byte integer, 31bits, and a sign “INT” NUMBER 10 It is possible to place a table constraint on columns of this type as an option to force values between -2^31 and 2^31. Or, place appropriate constraints such as: STATE_NO between 1 and 50 SMALLINT Two-byte integer, 15 bits and a sign NUMBER 6 It is possible to place a table constraint on columns of this type optionally to force values between -2^15 and 2^15. Or, place appropriate constraints such as: STATE_NO between 1 and 50 TINYINT One byte integer, 8 bits and no sign. Holds whole numbers between and 255. NUMBER 3 You may add a check constraint of x between 0 and 255 where x is column name. REAL Floating point number. Storage is four bytes and has a binary precision of 24 bits, a 7-digit precision. Data can range for -3.40E+38 to 3.40E+38 FLOAT The ANSI data type conversion to Oracle for REAL is FLOAT 63 . By default, the Oracle Migration Workbench maps REAL to FLOAT 24 that stores up to 8 significant decimal digits in Oracle. The Oracle NUMBER data type is used to store both fixed and floating-point numbers in a format that is compatible with decimal arithmetic. You may want to add a check constraint to constrain range of values. Also, you get different answers when performing operations on this data type as the Oracle NUMBER type is more precise and portable than REAL. Floating-point numbers can be specified in Oracle in the following format: FLOAT[ b ]. Where [ b ] is the binary precision b and can range from 1 to 126. [ b ] defaults to 126. To check what a particular binary precision is in terms of decimal precision, multiply [ b ] by 0.30103 and round up to the next whole number. FLOAT A floating point number. This column has 15-digit precision. FLOAT The ANSI data type conversion to Oracle for FLOAT p is FLOAT p . The ANSI data type conversion to Oracle for DOUBLE PRECISION is FLOAT 126 . By default, the Oracle Migration Workb