How many LONG columns are allowed in a table?

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

1

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

More SQL PLSQL Interview Questions

What is query execution plan in sql?

0 Answers  


how to get second highest salary in SQL(as/4000

29 Answers   iGate,


What is memory optimized?

0 Answers  


Explain autonomous transaction.

0 Answers  


Explain the difference between rename and alias?

0 Answers  






what is meant by urlencode and urldocode? : Sql dba

0 Answers  


what are the types of join and explain each? : Sql dba

0 Answers  


I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  


What is the purpose of the sql select top clause?

0 Answers  


Delete duplicate records in the emp table.

6 Answers   Oracle,


What are the steps for performance tuning.

0 Answers  


Is and as keyword in pl sql?

0 Answers  


Categories