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 ?    28 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 ?    18 Yes 0 No

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

Answer / fahad sami

1

Is This Answer Correct ?    12 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

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  


HOW CAN I FIND MAX SAL ,ENAME FROM EMP TABLE.

16 Answers  


what is the different between unique+not null & primary key,

4 Answers  


What is CYCLE/NO CYCLE in a Sequence?

2 Answers  


How do you optimize SQL queries ?

6 Answers   Oracle, Infosys, CarrizalSoft Technologies,






What is a cursor for loop ?

4 Answers  


IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  


how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  


can we delete the trigger in a view? if yes why if not why?

5 Answers   Tech Mahindra,


HOW TO PRINT * ** *** **** ***** BY USING SQL QUERY? (MAY BE USING SCRIPT)

8 Answers   BeBo Technologies,


How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  


How to execute multiple sql statements in a single annonymous block irrespective of the sql statement result?

2 Answers  






Categories