Working with the Oracle interface

Table B-2 lists class-level translations for Sybase ETL datatypes to Oracle datatypes.

**Table B-2: Data type mapping from Oracle interface to Sybase ETL**
ETL datatype	Oracle datatype	Size/precision	Minimum scale	Maximum scale
binary	BLOB	2147483647
binary	BFILE	2147483647
binary	RAW	2000	0	0
string	CLOB	2147483647	0	0
string	CHAR	2000	0	0
float	DECIMAL	38	0	0
integer	NUMBER	38	0	0
float	DOUBLE PRECISION	15	0	38
datetime	DATE	19	0	0
datetime	TIMESTAMP	28	0	9
string	VARCHAR2	4000	0	0
unicode	NCHAR	1000	0	0
unicode	NVARCHAR2	2000	0	0
unicode	NCLOB	2147483647	0	0