The following table describes the built-in general-purpose data types.
| Name | Alias | Description |
|---|---|---|
| BLOB | LONG RAW, RAW(n), BYTEA | Binary data |
| BOOLEAN | - | Logical Boolean (true/false) |
| CHAR [ (n) ] | CHARACTER [ (n) ] | Fixed-length character string of n characters |
| CLOB | LONG, LONG VARCHAR | Long character string |
| DATE | TIMESTAMP(0) | Date and time to the second |
| DOUBLE PRECISION | FLOAT, FLOAT(25) - FLOAT(53) | Double precision floating-point number |
| INTEGER | INT, BINARY INTEGER, PLS INTEGER | Signed four-byte integer |
| NUMBER | DEC, DECIMAL, NUMERIC | Exact numeric with optional decimal places |
| NUMBER(p [, s ]) | DEC(p [, s ]), DECIMAL(p [, s ]), NUMERIC(p [, s ]) | Exact numeric of maximum precision, p, and optional scale, s |
| REAL | FLOAT(1) - FLOAT(24) | Single precision floating-point number |
| TIMESTAMP [ (p) ] | - | Date and time with optional, fractional second precision, p |
| TIMESTAMP [ (p) ] WITH TIME ZONE | - | Date and time with optional, fractional second precision, p, and with time zone |
| VARCHAR2(n) | CHAR VARYING(n), CHARACTER VARYING(n), VARCHAR(n) | Variable-length character string with a maximum length of n characters |
| XMLTYPE | - | XML data |