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
- 16852 Views
- I also Faced
- E-Mail Answers
Answer Posted / bolearner
Long data type can't participate for any operation in SQL.
Only DML queries can be applied.
Can't apply any aggregate function on LONG colum.
Can't apply any analytical function on LONG colum.
Can apply sequence on LONG colum.
Can apply synonym for LONG column table.
Can create view for LONG column table and Mat view is not possible.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do I create a sql script?
What is benefit of creating memory optimized table?
how many values can the set function of mysql take? : Sql dba
How do you update sql?
What is the purpose of the partition table?
Explain cursor types?
what is the use of set statement in tsql? : Transact sql
Does truncate table reset auto increment?
Can a view be mutating? If yes, then how?
What is the difference between delete and truncate statement in sql?
Explain the update statement in sql
How do I partition a table in sql?
What is a memo field?
what is difference between delete and truncate commands? : Sql dba
What is a record in pl/sql?
