Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / PL SQL Data Types

 

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: 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.