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 is the use of index in sql?

0 Answers  

What is pls integer?

0 Answers  

How can I create a table from another table without copying any values from the old table?

8 Answers  

What are data types in pl sql?

0 Answers  

how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

1 Answers   IAS,

Can we join tables without foreign key?

0 Answers  

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

I have a table with 1 million records out of which 10,000 records are of unique records, then if I will implement index, then which type of index shall I use and why shall I use?

2 Answers   HSBC,

What are the set operators in sql?

0 Answers  

What is the best partition size for windows 10?

0 Answers  

How to pipe multiline string to isql?

0 Answers  

What is the difference between an inner join and an outer join?

0 Answers