The LONG datatype in PL/SQL is just like VARCHAR2.
The LONG datatype can store a maximum of 32760 bytes instead of 32767.
The LONG datatype is actually 7 bytes less than the VARCHAR2 type.
The Syntax for the LONG Datatype
variable_name LONG(size);
size is the size, in bytes, of the variable.
size must be a number between 1 and 32760.
Here are some sample declarations:
emp_comment LONG(32760);
The PL/SQL LONG differs from the database version of a LONG.
A LONG database column can store 2 gigabytes of data, whereas the PL/SQL version can store only 32760 bytes.