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 are sql commands classified?
How many postgresql users are there, worldwide?
how to check myisam tables for errors? : Sql dba
What is latest version of sql?
how to use like conditions? : Sql dba
How do you delete duplicates in sql query using rowid?
What are secondary keys?
How do you truncate?
Is delete faster than truncate?
How do I run a sql query?
How many sectors are in a partition?
Does db2 use sql?
Is sql similar to python?
What are the types of variables use in pl sql?
how do you tune the slow running queries in oracle db , explain the methodology