Data types for Oracle 9i

Oracle 9i provides a total of 16 scalar data types, as shown in table 7.4.
Table 7.4 Oracle 9i scalar data types

Name	Meaning
Char	Used to describe fixed-length character data, length <=2000 bytes
Varchar2	Used to describe variable-length character data, <=4000 bytes
NChar	Fixed-length character data for storing Unicode character sets, length <=1000 bytes
Nvarchar2	Variable-length character data for storing Unicode character sets, length <=1000 bytes
Number	Used to store integer or floating-point values
Date	Used to store date data
Long	Used to store variable length character data with a maximum length of 2GB
Raw	Variable-length character data for storing unstructured data, <=2000 bytes
Long Raw	Variable-length character data used to store unstructured data, <=2GB
rowID	Binary data used to store the physical address of the column in the table, consuming a fixed 10 bytes
Blob	Used to store up to 4GB of unstructured binary data
Clob	Used to store up to 4GB of character data
Nclob	Used to store up to 4GB of Unicode character data
Bfile	Used to store unstructured binary data in operating system files other than the database
Urowid	Used to store binary data that represents any type of column address
Float	Used to store floating point numbers