Answer / pavan_1981

only one

Answer / pravin

only 1 Long columns allowed in table

Answer / fahad sami

1

Answer / solomon information technologi

only one

Answer / anchit aneja

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

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.

What are all types of user defined functions?

0 Answers  

Which one of the following join types will always create a Cartesian Product? 1. CROSS JOIN 2. LEFT OUTER JOIN 3. RIGHT OUTER JOIN 4. FULL OUTER JOIN 5. INNER JOIN

2 Answers  

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

what is cursor procedure

1 Answers   iGate,

what is the difference between char and varchar data types? : Sql dba

0 Answers  

How to revise and re-run the last sql command?

0 Answers  

If you want a column to be part of the result set, after which SQL keyword does it belong? 1. SELECT 2. FROM 3. WHERE 4. GROUP BY 5. HAVING

10 Answers   HCL, TCS,

How to select random rows from a table?

0 Answers  

what is a database? : Sql dba

0 Answers  

What are the popular database management systems in the it industry?

0 Answers  

What is having clause in sql?

0 Answers  

What is a recursive join sql?

0 Answers