A data type is a classification identifying a particular type of information. The data type defines the allowable value for a field.
The following data types apply to an Oracle or SQL database:
Oracle = number (1, 0)
SQL = bit An integer data type that allows a value of 1, 0.
Oracle = timestamp (6)
SQL = datetime Defines a date that is combined with a time of day with fractional seconds that is based on a 24-hour clock.
Oracle = number (10, 0)
SQL = int An integer number that can be positive, negative or zero.
Oracle = nvarchar2
SQL = nvarchar A character data type of variable length. A character is any letter, number, space, punctuation mark, or symbol that can be typed on a computer.
Oracle = float
SQL = real A single-precision floating point number.
Oracle = nclob
SQL = ntext Variable-length character string. Used for text or combinations of text and numbers.
Oracle = number (3, 0)
SQL = tinyint Integer from 0 to 255.