(c) Instytut Informatyki Politechniki
Poznańskiej
4
Typy ANSI
ANSI
ORACLE
CHARACTER(n)
CHAR(n)
CHARACTER
VARYING(n)
CHAR
VARYING(n)
VARCHAR(n)
NATIONAL
CHARACTER(n)
NATIONAL
CHAR(n)
NCHAR(n)
NATIONAL
CHARACTER VARYING (n)
NATIONAL
CHAR VARYING(n)
NCHAR
VARYING(n)
NVARCHAR(n)
NUMERIC(p,s)
DECIMAL(p,s)
NUMBER(p,s)
INTEGER,
INT
SMALLINT
NUMBER(38)
FLOAT(b)
DOUBLE
PRECISION
REAL
NUMBER