| 21. 22. 1. What is a LONG type |
|
|
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: |
|
|
|
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.
|
|