ANSI Datatypes
Converted to Oracle Datatypes

ANSI SQL Data Type

Oracle Data Type

CHARACTER(n)

CHAR(n)

CHAR(n)

CHARACTER VARYING(n)

CHAR VARYING(n)

VARCHAR(n)

NATIONAL CHARACTER(n)

NATIONAL CHAR(n)

NCHAR(n)

NCHAR(n)

NATIONAL CHARACTER VARYING(n)

NATIONAL CHAR VARYING(n)

NCHAR VARYING(n)

NVARCHAR2(n)

NUMERIC(p,s)

DECIMAL(p,s)

NUMBER(p,s)

INTEGER

INT

SMALLINT

NUMBER(38)

FLOAT(b) 2

DOUBLE PRECISION 3

REAL 4

NUMBER

SQL/DS and DB2 Data Types
Converted to Oracle Data Types

SQL/DS or DB2 Data Type

Oracle Data Type

CHARACTER(n)

CHAR(n)

VARCHAR(n)

VARCHAR(n)

LONG VARCHAR(n)

LONG

DECIMAL(p,s) 1

NUMBER(p,s)

INTEGER

SMALLINT

NUMBER(38)

FLOAT(b) 2

NUMBER