(c) Instytut Informatyki Politechniki
Poznańskiej
13
Typy danych
Numerical Types
BINARY_INTEGER
DEC
DECIMAL
DOUBLE PRECISION
FLOAT
INT
INTEGER
NATURAL
NATURALN (not null)
NUMBER
NUMERIC
PLS_INTEGER
POSITIVE
POSITIVEN (not null)
REAL
SIGNTYPE
SMALLINT
Character Types
CHAR
CHARACTER
LONG
NCHAR
NVARCHAR2
RAW
STRING
VARCHAR
VARCHAR2
Boolean Type
BOOLEAN
Date Type
DATE
TIMESTAMP
INTERVAL
Composite Types
RECORD
TABLE
VARRAY
LOB Types
BFILE
BLOB
CLOB
NCLOB
Reference Types
REF CURSOR
REF object_type