Oracle basic data type | basic data type of Oracle 9i

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.