Oracle Data Type

Field type description other restrictions
----------------------------------------------------------------------------------------
Char fixed length string maximum length 2000 bytes
Varchar2 Variable Length string maximum length 4000 bytes can be indexed maximum length 749
Nchar Character Set-based fixed-length string maximum length 2000 bytes
Nvarchar2 variable-length string based on character set up to 4000 bytes
Date (day-month-year) DD-MM-YY (HH-MI-SS) is strictly tested with no problem
Long long string up to 2G (231-1) enough to store big part head books
Raw binary data with a fixed length can be up to 2000 bytes in length to store Multimedia Image sounds.
The maximum length of long raw binary data is 2 GB.
The maximum length of Blob binary data is 4 GB.
The maximum length of clob characters is 4 GB.
The maximum length of nclob characters depends on the character set.
The maximum length of bfile binary data stored outside the database is 4 GB.
The unique row number recorded in the rowid data table is in the format of 10 bytes **********. *****. * 0 or 1.
The maximum length of the unique row number recorded in the nrowid binary data table is 4000 bytes.
Number (P, S) number type P is an integer, and S is a decimal place
Decimal (P, S) numeric type P is an integer, S is decimal
Small integer
Float floating point number (38), Double Precision
Real Number (63) with higher precision