TIBCO Data Virtualization® Adapter Online Help > TDV Oracle Adapter > Oracle to TDV Data Types > Oracle 19c to TDV Data Types
 
Oracle 19c to TDV Data Types
The maximum VARBINARY length in Oracle 19c is 2000.
The following table shows the mapping from Oracle 19c data types to TDV data types.
Oracle 19c 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