Oracle data types and corresponding DataStage data types

Oracle data types and corresponding DataStage data types

Oracle data type	DataStage data type
CHAR(n BYTE)	SQL type: CHAR Length: n Scale: unset Extended: unset
CHAR(n CHAR ) single-byte	SQL type: CHAR Length: n Scale: unset Extended: unset
CHAR(n CHAR) multibyte	SQL type: NCHAR Length: n Scale: unset Extended: unset
CHAR single-byte	If the NLS_LENGTH_SEMANTICS database parameter is set to CHAR, then see CHAR(n CHAR). Otherwise, see CHAR(n BYTE) single-byte. In both cases, assume that n = 1.
CHAR multibyte	If the NLS_LENGTH_SEMANTICS database parameter is set to CHAR, then see CHAR(n CHAR). Otherwise, see CHAR(n BYTE) multibyte. In both cases, assume that n = 1
VARCHAR2(n BYTE)	SQL type: VARCHAR Length: n Scale: unset Extended: unset
VARCHAR2(n CHAR) single-byte	SQL type: VARCHAR Length: n Scale: unset Extended: unset
VARCHAR2(n CHAR) multibyte	SQL type: NVARCHAR Length: n Scale: unset Extended: unset
CLOB single-byte	SQL type: LONGVARCHAR Length: unset Scale: unset Extended: unset
CLOB multibyte	SQL type: LONGNVARCHAR Length: unset Scale: unset Extended: unset
LONG single-byte	SQL type: LONGVARCHAR Length: unset Scale: unset Extended: unset
LONG multibyte	SQL type: LONGNVARCHAR Length: unset Scale: unset Extended: unset
NCHAR(n)	SQL type: NCHAR Length: n Scale: unset Extended: unset
NCHAR	See NCHAR(n) and assume that n = 1.
NVARCHAR2(n)	SQL type: NVARCHAR Length: n Scale: unset Extended: unset
NCLOB	SQL type: LONGNVARCHAR Length: unset Scale: unset Extended: unset
NUMBER	SQL type: DOUBLE Length: unset Scale: unset Extended: unset
NUMBER (p, s) {p>=s} {s>=0}	SQL type: DECIMAL Length: p Scale: s Extended: unset
NUMBER(p, s) {p<s} {s>=0}	SQL type: DECIMAL Length: s Scale: s Extended: unset
NUMBER(p, s) {s<0}	SQL type: DECIMAL Length: p-s Scale: unset Extended: unset
FLOAT(p) {1 <=p <=63}	SQL type: FLOAT Length: unset Scale: unset Extended: unset
FLOAT(p) {64 <=p <= 127}	SQL type: DOUBLE Length: unset Scale: unset Extended: unset
BINARY_FLOAT	SQL type: FLOAT Length: unset Scale: unset Extended: unset
BINARY_DOUBLE	SQL type: DOUBLE Length: unset Scale: unset Extended: unset
LONG RAW	SQL type: LONGVARBINARY Length: unset Scale: unset Extended: unset
RAW(n)	SQL type: VARBINARY Length: n Scale: unset Extended: unset
BLOB	SQL type: LONGVARBINARY Length: unset Scale: unset Extended: unset
BFILE	SQL type: VARCHAR Length: 285 Scale: unset Extended: unset
DATE	SQL type: DATE Length: unset Scale: unset Extended: unset
TIMESTAMP(fsp)	SQL type: TIMESTAMP Length: unset Scale: fsp Extended: Microseconds
TIMESTAMP(fsp) WITH TIME ZONE	SQL type: TIMESTAMP Length: unset Scale: fsp Extended: Microseconds
TIMESTAMP(fsp) WITH LOCAL TIME ZONE	SQL type: TIMESTAMP Length: unset Scale: fsp Extended: Microseconds
TIMESTAMP	See TIMESTAMP(fsp) and assume that fsp=6.
TIMESTAMP WITH TIME ZONE	See TIMESTAMP(fsp) WITH TIME ZONE and assume that fsp=6.
TIMESTAMP WITH LOCAL TIME ZONE	See TIMESTAMP(fsp) WITH LOCAL TIME ZONE and assume that fsp=6.
INTERVAL YEAR (yp) TO MONTH	SQL type: VARCHAR Length: yp+4 Scale: unset Extended: unset
INTERVAL DAY TO SECOND (sp)	SQL type: VARCHAR Length: sp+13 Scale: unset Extended: unset
INTERVAL DAY (dp) TO SECOND	SQL type: VARCHAR Length: dp+17 Scale: unset Extended: unset
INTERVAL DAY (dp) TO SECOND (sp)	SQL type: VARCHAR Length: dp+sp+11 Scale: unset Extended: unset
INTERVAL YEAR TO MONTH	See INTERVAL YEAR (yp) TO MONTH and assume yp=2.
INTERVAL DAY TO SECOND	See INTERVAL DAY (dp) TO SECOND (sp) and assume that dp=2 and thatsp=6.
ROWID	SQL type: CHAR Length: 18 Scale: 18 Extended: unset
UROWID(n)	SQL type: VARCHAR Length: n Scale: unset Extended: unset
UROWID	See UROWID(n) and assume that n=4000.
XMLType stored as CLOB or  OBJECT_RELATIONAL single-byte	See CLOB single-byte.
XMLType stored as CLOB or  OBJECT_RELATIONAL multibyte	See CLOB multibyte.
XMLType stored as  BINARY XML	See BLOB.
Other	SQL type: UNKNOWN Length: unset Scale: unset Extended: unset