Oracle->DDM

CHAR(n)

n<=255

CHAR(n)

Yes

CHAR(n)

n>255

VARCHAR(n)

Yes

VARCHAR(Size)

Length (row size) ≤ 65535

VARCHAR(n)

Yes

VARCHAR(Size)

Length (row size) > 65535

TEXT

Yes

VARCHAR2(n)

-

VARCHAR(n)

Yes

NCHAR(n)

n<=255

NCHAR(n)

Yes

NCHAR(n)

n>255

NVARCHAR(n)

Yes

NVARCHAR2(n)

-

NVARCHAR(n)

Yes

NUMBER(p,s)

s>0

NUMBER(p,s)

Yes

NUMBER(p,s)

s<=0

NUMBER(p-s,0)

Yes

BINARY_FLOAT

-

FLOAT

Yes

BINARY_DOUBLE

-

DOUBLE

Yes

FLOAT(b)

b<=99

DECIMAL(b*0.30103*2,b*0.30103)

Yes

FLOAT(b)

b>99

DOUBLE

Yes

DATE

-

DATETIME

Yes

TIMESTAMP

-

TIMESTAMP

Yes

TIMESTAMP WITH LOCAL TIME ZONE

-

TIMESTAMP

Yes

TIMESTAMP WITH TIME ZONE

-

TIMESTAMP

Yes

INTERVAL

Incremental

VARCHAR(30)

No

INTERVAL

Full; 6 digit precision

VARCHAR(30)

Yes

BLOB

-

LONGBLOB

Yes

CLOB

-

LONGTEXT

Yes

NCLOB

-

LONGTEXT

Yes

LONG

-

LONGTEXT

Yes

LONG_RAW

-

LONGBLOB

Yes

RAW

-

VARBINARY

Yes

ROWID

-

VARCHAR(18)

Yes