- 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)