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.

can we create index on index?

7 Answers   iFlex, Symphony,

What is delete command in sql?

0 Answers  

Mention what does plv msg allows you to do?

0 Answers  

what are the differences between char and nchar? : Sql dba

0 Answers  

what is the difference between a local and a global temporary table? : Sql dba

0 Answers  

Is sql port 1433 encrypted?

0 Answers  

how to use like conditions? : Sql dba

0 Answers  

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

can we write stored function in out parameters? how to call through select statement? how to written more than one value plz give the exmple?

1 Answers  

What is pragma exception and how, when, where us

5 Answers  

Is sql injection illegal?

0 Answers  

3. Select sum(a) sum_1,max(a) max_1 ,count(a) count_1 from ( ( select 1 a from dual union all Select to_number(‘2011’) a from dual union all select 1 a from dual) union select 2 b from dual);

1 Answers   Fintellix,