Oracle Data Type Conversions

...

Info

NOTE: The

D s item

item	data types
r	true

listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

Info
NOTE: Dots (.) in the names of Oracle tables or table columns are not supported.

Access/Read

Source Data Type

Supported

D s item

item	Data Type

ANYDATA

N

ANYDATASET

N

ANYTYPE

N

BFILE

N

BINARY_DOUBLE

Y

Decimal

BINARY_FLOAT

Y

Decimal

BLOB

N

CHAR

Y

String

CLOB

Y

String

DATE

Y

Date/Time

DBURIType

Y

String

FLOAT

Y

Decimal

HTTPURIType

Y

String

INTERVAL_DAY TO SECOND

Y

String

INTERVAL_YEAR TO MONTH

Y

String

LONG RAW

Y

String (base64)

N

NCHAR

Y

String

NCLOB

Y

String

NUMBER

Y

Decimal / Integer

NVARCHAR2

Y

Integer

RAW

Y

String (base64)

ROWID

N

SDO_GEOMETRY

N

SDO_GEORASTER

N

SDO_TOPO_GEOMETRY

N

TIMESTAMP

Y

String

TIMESTAMP WITH LOCAL TIMEZONE

Y

String

TIMESTAMP WITH TIMEZONE

Y

String

URITYPE

Y

String

UROWID

N

VARCHAR2

Y

String

XDBUIRType

Y

String

XMLType

N

...

Page tree

Versions Compared

Old Version 4

New Version Current

Key

Access/Read