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
How delete all data from all tables in sql?
What are the ways on commenting in a pl/sql code?
Can a procedure in a package be overloaded?
Is there a 64 bit version of ssms?
what are properties of a transaction? : Sql dba
What does t sql mean?
Why schema is used in sql?
Write the alter statement to enable all the triggers on the t.students table.
Does sql profiler affect performance?
Give the order of sql select?
How do you use a while loop in pl sql?
What are the types of functions in sql?
What is the difference between local and global temporary table?
How do you use collections in procedure to return the resultset?
What is the best free sql database?