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.

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,

Is sql a programming?

0 Answers  

What are literals in sql server?

0 Answers  

What is exception? What are the types of exceptions?

0 Answers  

What is the basic structure of PL/SQL ?

6 Answers  

How to display the records between two range in Oracle SQL Plus?

0 Answers   MCN Solutions,

what are the advantages of sql ? : Sql dba

0 Answers  

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

0 Answers  

How can you fetch first 5 characters of the string?

0 Answers  

what is a foreign key ? : Sql dba

0 Answers  

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

What's the difference between inner join and left join?

0 Answers