How many LONG columns are allowed in a table

  • Interview Candidate
  • 5
  • 13573

Editorial / Best Answer

Gayathri Panchangam  

  • Member Since Aug-2008 | Sep 5th, 2008

Only one column can have LONG data type. And that column cannot be used in WHERE clause or in ORDER BY clause. Also we cannot add primary key constraint to that column only not to the whole table, that means we will give primary key to any column in the table except the column having the long data type. If we give, we get the error ORA-02269: key column cannot be of LONG datatype.

Showing Answers 1 - 5 of 5 Answers

Mathivanan

  • Jul 16th, 2005
 

Only one Long column can be present in a table.

  Was this answer useful?  Yes

Shiv Mangal Rahi

  • Jul 24th, 2006
 

Yeah. I do agree. Only one column of a table could be Long.

  Was this answer useful?  Yes

Nikhil_4_Oracle

  • Mar 5th, 2007
 



Hey all,
 
 You can have only one column of long in table , And this table can`t have 
 Primary key Constraint.
             --Nikhil 

  Was this answer useful?  Yes

Gayathri Panchangam

  • Sep 5th, 2008
 

Only one column can have LONG data type. And that column cannot be used in WHERE clause or in ORDER BY clause. Also we cannot add primary key constraint to that column only not to the whole table, that means we will give primary key to any column in the table except the column having the long data type. If we give, we get the error ORA-02269: key column cannot be of LONG datatype.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions