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 ?    20 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

How does one load ebcdic data? : aql loader

0 Answers  


How can you view the errors encountered in a trigger?

0 Answers  


how can we write a column values horizontal by using sql stmt; ex: select name from table_name;(actual output) a b c d require output is a b c d

5 Answers   Honeywell, Interact,


What is the difference between UNIQUE KEY and UNIQUE INDEX?

3 Answers   TCS,


What are Nested Tables? How will u delete 5 rows from Nested Tables

3 Answers   IBM,






what is global variable in pl/sql

1 Answers  


write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba

0 Answers  


Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,


Is sql microsoft?

0 Answers  


How many types of cursors are available in pl/sql?

0 Answers  


What is mutating sql table?

0 Answers  


what will be the output: select 1 from emp union all select 2 from emp;

2 Answers   iNautix,






Categories