Detailed description of the maximum length of varchar2 characters in Oracle

The maximum length of varchar2 storage is 4000.

The statement is as follows:

Create table test (id varchar2 (4001); an error is reported during execution.

If you change the statement to the following, the execution is successful.

Create table test (id varchar2 (4000 ));

Problem analysis

When used to define the table type, the maximum length of varchar2 is 4000 bytes, as shown in Figure 1. When the value exceeds, an error is returned:

Figure 1:

When used as a variable defined in PL/SQL programs, the maximum size is 32767 bytes. The number of characters that can be stored depends on the character set settings, as shown in figure 2:

Figure 2:

When the string to be stored exceeds the maximum limit of varchar2, you must consider using a large object type CLOB or BLOB.