| Numbers | | |
NUMBER | NUMERIC | NUMBER |
FLOAT | REAL | FLOAT |
BINARY_FLOAT | REAL | FLOAT |
BINARY_DOUBLE | DOUBLE | FLOAT |
| Times | | |
DATE | TIMESTAMP | TIMESTAMP_NTZ |
TIMESTAMP | TIMESTAMP | TIMESTAMP_NTZ |
TIMESTAMP WITH TIME ZONE | TIMESTAMPTZ | TIMESTAMP_TZ |
TIMESTAMP WITH LOCAL TIME ZONE | TIMESTAMP | TIMESTAMP_LTZ |
INTERVAL YEAR TO MONTH, INTERVAL DAY TO SECOND | TEXT | VARCHAR(64) |
| Strings | | |
CHAR | TEXT | VARCHAR |
NCHAR | TEXT | VARCHAR |
VARCHAR2 | TEXT | VARCHAR |
NVARCHAR2 | TEXT | VARCHAR |
CLOB | TEXT | VARCHAR |
NCLOB | TEXT | VARCHAR |
(Any Oracle type not in the above list) | TEXT | VARCHAR(4000) |
| Blobs | | |
RAW | BYTEA | BINARY |
BLOB | BYTEA | BINARY |
