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
What is nvarchar in sql?
How can you create an empty table from an existing table?
What is sql character function?
explain advantages of innodb over myisam. : Sql dba
Explain the structure of pl/sql in brief.
Is there a 64 bit version of ssms?
What is offset and limit in sql?
Is full outer join same as cross join?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is the use of sqldataadapter?
what is the difference difference between procedure and packages
how many columns can be used for creating index? : Sql dba
Explain the difference between sql and mysql.
What are the different types of dbms?