Is it possible to use LONG columns in WHERE clause or ORDER
BY?
- 3 Answers
- 16110 Views
- I also Faced
- E-Mail Answers
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 faster join or subquery?
What are the advantages of sql?
What is the difference between the conventional and direct path loader? : aql loader
How much does sql certification cost?
What is offset and limit in sql?
How does pl sql work?
What is the difference between alter trigger and drop trigger statements?
What is nosql vs sql?
Explain how exception handling is done in advance pl/sql?
Name some usages of database trigger?
Which is faster union or join?
What are the types of optimization?
What is difference between stored procedure and trigger?
What is data control language?
What can you do with pl sql?
