Oracle Data Types

Basic Data Types

→ VARCHAR2(n)

→ CHAR(n)

→ NUMBER(p,s)

→ DATE

National Character Set data Types – stores languages like Chinese

→ NVARCHAR2(n)

→ NCHAR(n)

More Numeric Data Types

→ Float(p)

→ INTEGER

→ SMALLINT

Other Simple Data Types

→ TIMESTAMP(p)

→ ROWID

→ UROWID

Binary Object Data Types

→ BLOB – video, sound, images files

→ CLOB – large text files

→ NCLOB – national character set large text files

Referencing Data Types

→ REF – pointers reference to somewhere else in the database

→ BFILE – pointers to an object in or outside the database

User Defined Data Types

→ Nested Tables

→ VARRAY

Advanced Data Types

→ XML Type

→ Spatial Type

→ Media Type

→ “Any” Type