• Data Types
  • Data Types
  • "10eb7bf9-ae25-470b-96d0-4111dd85970b
  • 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:
  • An integer data type that allows a value of 1, 0.
  • Oracle = number (1, 0)
  • Defines a date that is combined with a time of day with fractional seconds that is based on a 24-hour clock.
  • Oracle = timestamp (6)
  • An integer number that can be positive, negative or zero.
  • Oracle = number (10, 0)
  • A character data type of variable length.
  • Oracle = nvarchar2
  • A character is any letter, number, space, punctuation mark, or symbol that can be typed on a computer.
  • A single-precision floating point number.
  • Oracle = float
  • Used for text or combinations of text and numbers.
  • Variable-length character string.
  • Oracle = nclob
  • Integer from 0 to 255.
  • Oracle = number (3, 0)