Data Integration Connectors
- Data Integration Connectors
- All Products
Oracle Data Type
| Transformation Data Type
| Description
|
---|---|---|
Blob
| Binary
| 1 to 104,857,599 characters
|
Char
| String
| 1 to 104,857,600 characters
|
Clob
| Text
| 1 to 104,857,599 characters
|
Date
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D
|
Number
| Double
| Precision 15, scale 0
|
Number(p,s)
| Decimal
| Precision of 1 to 28, scale of 0 to 28
|
Timestamp
| Date/Time
| Jan 1, 0001 A.D. to Dec 31, 9999 A.D (precision to the nanosecond)
|
Varchar
| String
| 1 to 104,857,600 characters
|
Varchar2
| String
| 1 to 104,857,600 characters
|
nChar
| String
| 1 to 104,857,600 characters
|
nVarchar2
| String
| 1 to 104,857,600 characters
|