Multiple choice technology databases

WHAT IS THE MAX LENGHT OF VARCHAR2 DATATYPE IN PL/SQL?

  1. 32767

  2. 1024

  3. 255

  4. 32765
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In PL/SQL, VARCHAR2 can hold up to 32767 bytes (32KB), which is much larger than the SQL limit of 4000 bytes. This extended capacity is useful for procedural code processing larger text strings. Options like 1024 or 255 are outdated limits from earlier versions or different contexts.

Keep practicing — related questions