The database has no capacity limit. The maximum table space does not exceed the initial setting value. There is no capacity limit for tables and fields. Too much data will involve storage efficiency, and each data type has a maximum capacity.

For example:

CHAR fixed-length string maximum length 2000 bytes

VARCHAR2 variable-length string maximum length 4000 bytes maximum indexable length 749

NCHAR The maximum length of a fixed-length string depending on the character set is 2000 bytes

NVARCHAR2 The maximum length of a variable-length string depending on the character set is 4000 bytes

DATE Date (day- Month-Year) DD-MM-YY (HH-MI-SS) After rigorous testing, no thousand-bug problem

LONG The maximum length of ultra-long string is 2G (231-1), enough to store large works

RAW fixed-length binary data with a maximum length of 2000 bytes can store multimedia images, sounds, etc.

LONG RAW variable-length binary data with a maximum length of 2G Same as above

BLOB The maximum length of binary data is 4G

CLOB The maximum length of character data is 4G

NCLOB The maximum length of character data depending on the character set is 4G

BFILE is stored outside the database The maximum length of binary data is 4G

ROWID The unique row number recorded in the data table 10 bytes ********.****.**** format, * is 0 or 1 < /p>

NROWID The maximum length of the unique row number recorded in the binary data table is 4000 bytes

NUMBER(P,S) The number type P is the integer digit and S is the decimal digit

REAL real number type NUMBER(63), higher precision