How many LONG columns are allowed in a table

Interview Candidate
Jul 16th, 2005
11
13440

Editorial / Best Answer

Gayathri Panchangam

Profile Answers by Gayathri Panchangam Questions by 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 - 11 of 11 Answers

Mathivanan

Jul 16th, 2005

Only one Long column can be present in a table.

Shiv Mangal Rahi

Jul 24th, 2006

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

rampratap409
Profile Answers by rampratap409 Questions by rampratap409

Dec 11th, 2006

Only one column and this column can not be used in where clause or order by clause.

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

Gayathri Panchangam
Profile Answers by 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.