Definition:
In Oracle PL/SQL, LONG refers to a datatype which belongs to the character datatype family. It can be used for character data up to 2GB.
Note that Oracle has deprecated the use of LONG over
LOB due to its multiple inherent restrictions and complex handling requirements. It is supported ONLY for its backward compatibility. Do not use the LONG datatype.
A table can have only one LONG column, which cannot be indexed and used in a WHERE clause. A LONG also cannot be returned from functions.
Example Usage
SQL> CREATE TABLE LONGTABLE
(KEY NUMBER,
DESCRIPTION LONG);
Table created.
Related Code Snippets:
