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.