Page Comparison

VARCHAR2

string

NVARCHAR2

string

VARCHAR

string

NUMBER

decimal

For NUMBER types with a defined precision and scale.

NUMBER

string

For NUMBER types defined without a defined precision and scale.
Users can manually set output schema to map it to Decimal.

FLOAT

double

LONG

string

DATE

timestamp

BINARY_FLOAT

float

BINARY_DOUBLE

double

TIMESTAMP

timestamp

TIMESTAMP WITH TIME ZONE

string

Timestamp string in the following format: "2019-07-15 15:57:46.65 GMT"

TIMESTAMP WITH LOCAL TIME ZONE

timestamp

INTERVAL YEAR TO MONTH

string

Oracle's 'INTERVAL YEAR TO MONTH' literal in the standard format: "year[-month]"

INTERVAL DAY TO SECOND

string

Oracle's 'INTERVAL DAY TO SECOND' literal in the standard format:"[day] [hour][:minutes][:seconds[.milliseconds]"

RAW

bytes

LONG RAW

bytes

ROWID

string

UROWID

string

CHAR

string

NCHAR

string

CLOB

string

NCLOB

string

BLOB

bytes

BFILE

bytes

BFILE data type is not supported for the sink