Oracle 11g Data Type | TDV Data Type |
ANYDATA | OTHER |
ANYDATASET | OTHER |
ANYTYPE | OTHER |
BINARY DOUBLE | DOUBLE |
BINARY FLOAT | FLOAT |
INTERVAL DAY(0) TO SECOND(0) – INTERVAL DAY(9) TO SECOND(9) | VARCHAR |
INTERVAL YEAR(0) TO MONTH – INTERVAL YEAR(9) TO MONTH | VARCHAR |
SDO_GEORASTER | OTHER |
SI_STILLIMAGE | VARBINARY |
TIMESTAMP | TIMESTAMP |
TIMESTAMP(0) – TIMESTAMP(9) | TIMESTAMP |
TIMESTAMP(0) WITH LOCAL TIME ZONE – TIMESTAMP(9) WITH LOCAL TIME ZONE | TIMESTAMP |
TIMESTAMP(0) WITH TIME ZONE – TIMESTAMP(9) WITH TIME ZONE | TIMESTAMP |
URITYPE | OTHER |
UROWID | VARCHAR |
XMLTYPE | XML |