Interested to Buy Any Domain ? << Click Here >> for more details...
Is it possible to use LONG columns in WHERE clause or ORDER
BY?
- 3 Answers
- 17053 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
How can check sql version from command line?
What is PL/SQL Records?
Explain the advantages and disadvantages of stored procedure?
What do you mean by query optimization?
Where is sql database stored?
how to create a table index in mysql? : Sql dba
What is the difference between python and sql?
How to add a column ‘salary’ to a table employee_details?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
List the various privileges that a user can grant to another user?
What is a primary key sql?
What are system versioned tables?
what is the difference between blob and text? : Sql dba
How do you modify a column in sql?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
