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.
SQL> CREATE TABLE LONGTABLE
Related Code Snippets: