Is it possible to use LONG columns in WHERE clause or ORDER
BY?
Answer Posted / pavan_1981
no its not possible to use long columns in WHERE or ORDERBY
clause.other restrictios on LONG column are
1.there can be only colum of long data type in a table.
2.no constraints can be defined on long column.
3.a long column will not be cpied when u create a new table
from existing table using a subquery.
Is This Answer Correct ? | 21 Yes | 4 No |
Post New Answer View All Answers
what is recursive stored procedure? : Sql dba
What is meant by cursor in sql?
Can we use the cursor's to create the collection in PL/SQL?
Is sql an operating system?
How does sql store data?
What is cursor and its types?
What is not in sql?
How many times can we commit in a loop?
What is the main difference between sql and pl/sql?
What is application trigger?
What is the difference between null value, zero, and blank space?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What has stored procedures in sql and how we can use it?
explain the difference between myisam static and myisam dynamic. : Sql dba
Who developed sql?