A
Data Type Conversion

BYTE

RAW

-

BYTE VARYING

RAW

-

C, CHAR

CHAR

-

DATE

DATE

DATE range is January 1, 1582 through December 31, 2382.

DECIMAL

NUMBER(p[,s])

If precision and scale are not specified, DECIMAL is converted to NUMBER(16)

FLOAT

FLOAT(49)

-

FLOAT4

FLOAT(23)

-

FLOAT8

FLOAT(49)

-

INTEGER

NUMBER(10)

NUMBER range is -2,147,483,647 to 2,147,483,647

INTEGER1

NUMBER(3)

-

INTEGER2

NUMBER(5)

NUMBER range is -32,767 to 32,767

INTEGER4

NUMBER(10)

NUMBER range is -2,147,483,647 to 2,147,483,647

LONG BYTE

LONG RAW

-

LONG VARCHAR

LONG

-

MONEY

FLOAT(49)

-

OBJECT_KEY

CHAR(16)

-

SMALLINT

NUMBER(5)

NUMBER range is -32,767 to 32,767

TABLE_KEY

CHAR(8)

-

TEXT

VARCHAR2

The length of a TEXT data type ranges from 1 to 2000 characters

VARCHAR

VARCHAR2

The length of a VARCHAR data type ranges from 1 to 2000 characters