|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
- Follow @renenyffenegger
long (datatype in Oracle)
With 9i (I believe) and later versions, Oracle deprecates using the
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.