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 an inner join sql?
Is there a way to automate sql execution from the command-line, batch job or shell script?
Are dml statements autocommit?
what is a trigger? : Sql dba
What are analytical functions in sql?
Differentiate between pl/sql and sql?
what is the command line end user interface - mysql? : Sql dba
How do I remove sql developer from windows 10?
What is a parameter query?
how to use in conditions? : Sql dba
Which software is used for pl sql programming?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
what are the differences between char and varchar? : Sql dba
Which table is left in left join?
Is sql pronounced sequel or sql?