Basic Data Types of Oracle 9i
Data Type |
Description |
Char |
Fixed-length bytes data with a maximum length of 2 kb |
Nchar |
Data of UNICODE character set with a fixed length of 2 kb |
Varchar2 |
Variable-length bytes data up to 4000 characters |
Nvarchar2 |
Stores variable-length bytes data of the Unicode character set. The maximum length is 4 kb. |
Number |
Store integer or floating point data |
Date |
Store date data |
Long |
Store variable-length data with a maximum length of 2 GB |
Raw |
Store variable-length characters of unstructured data, up to 2 kb |
Long raw |
Variable-length character data for storing unstructured data, up to 2 GB |
Rowid |
Stores the binary data of the physical address of the column in the table, occupying 10 fixed bytes |
Blog |
Large binary object with a maximum length of 4 GB |
Clob |
Large object with a maximum length of 4 GB |
Nclob |
Stores up to 4 GB of UNICODE character data |
Bfile |
Store unstructured binary data in operating system files other than databases |
Urowid |
Stores binary data that represents any type of column address |
Float |
Storage floating point number |
Oracle 9i has three data types: basic data type, set type, and link type.
- basic data type: it is an inseparable data type. The table above provides 16 Basic Data Types for Oracle 9i.
- set data types: sequence, array, and table types.
- relational data type: Also known as ref. It defines the relationship with other objects in reference mode, it stores pointers to data of different object data tables.