A brief introduction to Oracle 9i 16 data types __oracle

A brief introduction to Oracle 9i's 16 types of data

Oracle 9i provides a total of 16 scalar data types, as shown below.

　　the scalar data type name meaning of Oracle 9i

Char is used to describe fixed-length character data, length <=2000 bytes

VARCHAR2 used to describe variable-length character data, <=4000 bytes

NChar used to store fixed-length character data for Unicode character sets, length <=1000 bytes

NVARCHAR2 used to store variable-length character data for Unicode character sets, length <=1000 bytes

Number is used to store integer or floating-point values

Date is used to store dates data

Long used to store variable length character data with a maximum length of 2GB

Raw used to store variable-length character data for unstructured data, length <=2000 bytes

Long raw used to store variable-length character data for unstructured data, length <=2GB

ROWID binary data used to store the physical address of a column in a table, consuming a fixed 10 bytes

BLOBs are 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 is 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 is used to store floating-point numbers