Is it possible to use LONG columns in WHERE clause or ORDER
BY?
- 3 Answers
- 15823 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
what are the differences between char and varchar? : Sql dba
what are the advantages of sql ? : Sql dba
What is the difference between pl and sql?
What is online transaction processing (oltp)?
what is 'mysqladmin' in mysql? : Sql dba
Is stored procedure faster than query?
How delete all data from all tables in sql?
How do I make sql search faster?
what are all types of user defined functions? : Sql dba
What is embedded sql with example?
What do you understand by case manipulation functions?
How can the performance of a trigger be improved?
How do I view a procedure in sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Why do we use procedures in sql?
