The following are the restrictions on the LONG datatype:
1. There can be only one column of datatype LONG in a table.
2. You can not use the LONG datatype column for GROUP BY, ORDER BY, WHERE or CONNECT BY clauses.
3. Character functions can not be applied to LONG columns.
Note:PL/SQL LONG varoabel is different from LONG datatype for columns.
No comments:
Post a Comment