long (datatype in Oracle)

With 9i (I believe) and later versions, Oracle deprecates using the long datatype in favor of the lob (clob, nclob and blog) datatypes. It is only supported for backward compatibility.

A long can be specified at most for a table. Trying to have a table with two longs results in a ORA-01754: a table may contain only one column of type LONG.

It can not be used in create type as an attribute of the defined type.

It can not be used in where conditions.

There can be no indexes on long columns.

Regular expressions are not possible.

long can not be returned from a stored function.

SQL can not call functions that have an attribute of type long.

And even more restrictions.

Other datatypes