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

What is a mutating table and a constraining table?

0 Answers  


If we declare constraints Unique and Not null on a single column then it will act as a Primary key, so what is the use of primary key??

3 Answers  


What is the difference between left and left outer join?

0 Answers  


difference between table level constraint and column level and advantages of table level constraint

4 Answers   Doyensys,


how to get a list of indexes of an existing table? : Sql dba

0 Answers  






Where the Pre_defined_exceptions are stored ?

2 Answers  


how to create a new view in mysql? : Sql dba

0 Answers  


How to fetch common records from two tables?

0 Answers  


Can we call a function containing dml statements in a select query?

0 Answers  


Mention what does the hierarchical profiler does?

0 Answers  


Where is pl sql used?

0 Answers  


SELECT emp_num, years, SUM(salary) FROM sales UNION ALL SELECT emp_id, SUM(takehomepay) FROM marketing What error is present in the sample code above? 1. Queries being combined with the UNION ALL statement are not allowed to have SELECT lists with a different number of expressions. 2. You are not allowed to use aggregate functions within two queries joined by a UNION ALL statement. 3. The UNION ALL statement incorrectly combines the "years" result from the first query with the "SUM (takehomepay)" result from the second query. 4. Unless the UNION ALL statement is replaced with a UNION statement, the queries will return duplicates. 5. The "emp_id" column from the second query must be renamed (or aliased) as "emp_num" so that it corresponds to the column name from the first query. Otherwise, the queries will not execute.

3 Answers  






Categories