How many LONG columns are allowed in a table?

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / guest

6 Answers
24964 Views
CTS, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How many LONG columns are allowed in a table?..

Answer / pavan_1981

only one

Is This Answer Correct ?

31 Yes

0 No

How many LONG columns are allowed in a table?..

Answer / pravin

only 1 Long columns allowed in table

Is This Answer Correct ?

21 Yes

0 No

How many LONG columns are allowed in a table?..

Answer / fahad sami

Is This Answer Correct ?

14 Yes

1 No

How many LONG columns are allowed in a table?..

Answer / solomon information technologi

only one

Is This Answer Correct ?

5 Yes

0 No

How many LONG columns are allowed in a table?..

Answer / anchit aneja

only 1...,forsure...!!!

Is This Answer Correct ?

4 Yes

0 No

How many LONG columns are allowed in a table?..

Answer / harshit varshney

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.

Is This Answer Correct ?

4 Yes

0 No

Post New Answer