Designer Guide

Back Next

Oracle and Transformation Datatypes

The following table compares Oracle datatypes and transformation datatypes:

Oracle	Range	Transformation	Range
Blob	Up to 4 GB	Binary	1 to 104,857,600 bytes
Char(L)	1 to 2,000 bytes	String	1 to 104,857,600 characters
Clob	Up to 4 GB	Text	1 to 104,857,600 characters
Date	Jan. 1, 4712 B.C. to Dec. 31, 4712 A.D. Precision 19, scale 0	Date/Time	Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Long	Up to 2 GB	Text	1 to 104,857,600 characters If you include Long data in a mapping, the Integration Service converts it to the transformation String datatype, and truncates it to 104,857,600 characters.
Long Raw	Up to 2 GB	Binary	1 to 104,857,600 bytes
Nchar	1 to 2,000 bytes	Nstring	1 to 104,857,600 characters
Nclob	Up to 4 GB	Ntext	1 to 104,857,600 characters
Number	Precision of 1 to 38	Double	Precision of 15
Number(P,S)	Precision of 1 to 38, scale of 0 to 38	Decimal	Precision of 1 to 28, scale of 0 to 28
Nvarchar2	1 to 4,000 bytes	Nstring	1 to 104,857,600 characters
Raw(L)	1 to 2,000 bytes	Binary	1 to 104,857,600 bytes
Timestamp	Jan. 1, 4712 B.C. to Dec. 31, 9999 A.D. Precision 19 to 29, scale 0 to 9 (precision to the nanosecond)	Date/Time	Jan 1, 0001 A.D. to Dec 31, 9999 A.D. (precision to the nanosecond)
Varchar(L)	1 to 4,000 bytes	String	1 to 104,857,600 characters
Varchar2(L)	1 to 4,000 bytes	String	1 to 104,857,600 characters
XMLType based CLOB storage	Up to 4 GB	Text	1 to 104,857,600 characters