How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?

Post

View All

Gaurav Malviya

How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?

By Gaurav Malviya in SQL Server on Jan 14 2014

0
2.8k
1

Post Your Answer

Jan, 2014 14
Only one LONG column is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.
- 0

What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type?

What are the pre-requisites to modify datatype of a column and to add a column with NOT NULL constraint?