Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL LONG Datatype      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: LONG

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:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 99 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?