Oracle 9i Data Type

Oracle 9i provides 16 scalar data types, as shown in Table 7.4. Table 7.4 scalar Data Types of Oracle 9i Name Description Char Used to describe the fixed-length bytes data. The length is <= 2000 bytes. Varchar2 Used to describe variable-length bytes of data. The length is <= 4000 bytes. Nchar It is used to store the fixed-length bytes data of the Unicode character set. The length is <= 1000 bytes. Nvarchar2 Used to store variable-length bytes data of the Unicode character set. The length is <= 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 2 GB Raw Long character data used to store unstructured data. The length is <= 2000 bytes. Long raw Long character data used to store unstructured data. The length is <= 2 GB Rowid It is used to store the binary data of the physical address of the column in the table, occupying 10 fixed bytes. Blob Used to store up to 4 GB of unstructured binary data Clob Used to store up to 4 GB of character data Nclob Used to store up to 4 GB of UNICODE character data Bfile Used to store unstructured binary data in operating system files other than databases Urowid Stores binary data that represents any type of column address. Float Used to store floating point numbers