LONG type limit:
You can use long in SELECT
SELECT clause can be used in Update
You can use the VALUES clause in Insert.
Each table can only allow a long column.
LONG column cannot list integrity constraints (except null.not NULL)
The LONG column cannot be indexed.
Procedure or storage function cannot accept a LONG type function
Storage function cannot return long value
Long can't appear in the following:
Select in WHER, GROUP BY, ORDER BY, Connect By, Distinct
Cannot do Substr, Instr, INSTR
Expressions or conditions,
The child is not available in the subquery or collection.
CREATE TABLE ... AS SELECT cannot be used in long.
