SQL DATA TYPES

DATA TYPES:

CHARACTER(n)----- Character string.
VARCHAR2(n)------Character string.
BOOLEAN---------- Stores TRUE or FALSE values
NUMERIC(p,s)------ Exact numerical, precision p, scale s.
Example: NUMERIC(5,2) is a number that has 3 digits before the decimal and 2 digits after the decimal
NUMBER(n)---------Numeric value with n digits.
DATE--------------Stores year, month, and day values
TIME------------- Stores hour, minute, and second values
INTEGER-----------Integer numerical (no decimal). Precision 10
FLOAT------------ Approximate numerical, mantissa precision 16