Is it possible to use LONG columns in WHERE clause or ORDER
BY?
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
Why do we use procedures in sql?
Why do we need cursor in pl sql?
What is the difference between null value, zero, and blank space?
Can pl sql procedure have a return statement?
How to run sql functions in pl/sql?
What is trigger in sql and its types?
how do you login to mysql using unix shell? : Sql dba
How much does sql certification cost?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
What are the basic techniques of indexing?
what are numeric data types? : Sql dba
Is hadoop a nosql?
what are the differences between require and include, include_once and require_once? : Sql dba
Is a view faster than a stored procedure?
What is an emotional trigger?