Table of Contents

Search

  1. Preface
  2. Introduction to Oracle Connector
  3. Oracle connections
  4. Synchronization tasks with Oracle Connector
  5. Mappings and mapping tasks with Oracle Connector
  6. Replication tasks
  7. Troubleshooting
  8. Appendix A: Data type reference

Oracle Connector

Oracle Connector

Oracle and transformation data types

Oracle and transformation data types

The following table lists the Oracle data types that
Data Integration
supports and the corresponding transformation data types:
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

0 COMMENTS

We’d like to hear from you!