MIME-Version: 1.0 Content-Location: file:///C:/C97E4D13/ANSItoOracleDatatypes.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii"
ANSI Dat= atypes Converted to Oracle Datatypes
ANSI SQL Data Type |
Oracle Data Type |
CHARACTER(n<=
/i>) |
CHAR(n) = |
CHARACTER VARYING(n) |
VARCHAR(n) |
NATIONAL CHARACTER(n) |
NCHAR(n)= |
NATIONAL CHARACTER VARYING(n) |
NVARCHAR2(n<= /i>) |
NUMERIC(p,s) |
NUMBER(p,s) |
INTEGER |
NUMBER(38) |
FLOAT(b)=
2 |
NUMBER |
SQL/DS and DB2 Data Types Converted to Oracle Data Types
SQL/DS or DB2 Data Type= |
Oracle Data Type |
CHARACTER(n<= /i>) |
CHAR(n) = |
VARCHAR(n) |
VARCHAR(n) |
LONG VARCHAR(n) |
LONG |
DECIMAL(p,s) 1 |
NUMBER(p,s) |
INTEGER |
NUMBER(38) |
FLOAT(b)= 2 |
NUMBER |