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.