Oracle data type
Commonly used database field types are as follows:
Field Type Chinese Description Limit Condition Other Description CHAR Fixed Length String Maximum Length 2000 BYtes VARCHAR2 Variable Length String Large Length 4000 Bytes Maximum Length 749 NCHAR The fixed length string fixed by the character set 2000 BYtes NVARCHAR2 Depending on the variable length string of the character set, the maximum length of the variable length string (day-month - year) DD-MM-YY (HH-MI-SS) has been strictly tested, there is no tapless problem long string Maximum length 2g (231-1) sufficient to store large-headed works RAW fixed length binary data maximum length 2000 BYTES Multimedia image sound, etc. Long Raw variable length binary data maximum length 2G binary data maximum length 4G Clob Character data maximum length 4G nclob Depending on the character set Character data maximum length 4G bfile stored in the binary data outside the database, the only line number 10 bytes ********. ********. ** **. **** Format, * is the only line number of the 0 or 1 nrowid binary data table recorded in the maximum length of 4000 BYtes Number (p, s) digital type P is an integer bit, S is a decimal Decimal (P, S ) Digital type P is an integer bit, S is a small integer floating point number type Number (38), Double Precision Real Real Type Number (63), Higher Accuracy
