- Only one LONG column is allowed per table
- LONG columns cannot be indexed
- LONG columns cannot apear in integrity constraints
- LONG columns cannot be used in GROUP BY, ORDER BY, CONNECT BY clauses or with
DISTINCT operator in SELECT statements
- LONG columns cannot be referenced by SQL functions
- LONG columns cannot be used in the SELECT list of a subquery or queries
combined by set operators (UNION ALL, INTERSECT, or MINUS)
- LONG columns cannot be used in SQL expresions
- LONG datatype is inconsistant between SQL*PLUS and PL/SQL
- LONG columns cannot be used in distributed SQL statements
- A table with a LONG datatype column cannot be partitioned
Zemin Luo
Senior Consultant, KPMG
Received on Mon Sep 21 1998 - 12:43:13 CDT