Oracle Common database field types

Oracle Common database field types

Common database field types are as follows: Field type Chinese description restrictions other description CHAR fixed length string max length bytes VARCHAR2 variable length string maximum length 4000 bytes can do index maximum length 749 NCHAR by character Set fixed length string maximum length bytes NVARCHAR2 variable length string maximum length based on character set 4000 bytes Date Date (day-month-year) Dd-mm-yy (HH-MI-SS) rigorously tested, no bug problem L ONG long string Maximum length 2G (231-1) enough to store a large book RAW fixed-length binary data maximum length of bytes can store multimedia image sound, etc. long RAW variable length binary data maximum length 2G ibid. BLOB Binary Data Maximum length 4G CLOB character Data maximum length 4G NCLOB character data based on character set maximum length 4G BFILE The maximum length of binary data stored outside the database 4G ROWID the unique line number recorded in the data table is bytes ********.****. Format, * 0 or 1 Nrowid a unique line number in a binary data table maximum length 4000 bytes number (p,s) numeric type P is an integer digit, S is a decimal decimal (p,s) Number type P is an integer digit, S is a decimal integer type Small integer float floating point number type number (38), double real real number type number (63), higher precision

Oracle Common database field types