Data types v15
The following table shows 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 | 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 |
numeric_types character_types binary_data date_time_types boolean_type xml_type