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 ?    29 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 ?    19 Yes 0 No

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

Answer / fahad sami

1

Is This Answer Correct ?    13 Yes 1 No




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

Answer / solomon information technologi

only one

Is This Answer Correct ?    4 Yes 0 No

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

Answer / anchit aneja

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

Is This Answer Correct ?    3 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 ?    3 Yes 0 No

Post New Answer



More SQL PLSQL Interview Questions

What is a 'instead of trigger'?

3 Answers   TCS, Eenadu,


Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,


i have some prob lem to tell me about my self in interview first round ...

0 Answers  


what is mean by forward declaration and where we'll use it.

4 Answers   TCS,


What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   TCS, Cap Gemini, Infosys,






What are the rules to be applied to nulls whilst doing comparisons?

0 Answers  


what is SCALAR Queries?

2 Answers   ITC Infotech,


Difference between NVL, NVL2 and NULLIF

1 Answers   CTS, Metric Stream,


How to call the function and Procedure in trigger?

3 Answers   IBM,


What are the cursor attributes used in PL/SQL ?

4 Answers  


if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  


What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,






Categories